How to Open Format Data Series in Excel

Tired of generic, hard-to-read Excel charts? Formatting your data series is the single best way to make your charts clear, professional, and impactful. This tutorial will walk you through four simple methods to access the "Format Data Series" pane, the control center for customizing your chart's appearance. Then we’ll explore the powerful options you'll find inside.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is a "Data Series" in Excel?

Before we dive into formatting, let's quickly clarify what a data series is. In simple terms, a data series is a group of related data points on your chart. For example, if you're plotting monthly sales for the year, all twelve monthly sales figures make up a single data series. In a chart, this might be represented by:

• A set of columns of the same color in a column chart.
• A single line in a line chart.
• The collection of slices that make up a pie chart.
• A group of dots of the same color in a scatter plot.

Why bother formatting it? Because good formatting transforms a confusing chart into a clear story. It helps your audience distinguish between different data sets, highlights the most important information, and makes your entire report look more polished and professional. Ditching Excel's default blue and orange is the first step toward creating visuals that command attention.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: The Quick Right-Click

This is by far the most common and intuitive way to get to the formatting options. It’s a simple two-step process that works every time.

Step-by-Step Instructions:

1. Click on the Data Series: First, left-click on any part of the data series you want to format. For example, click on one of the bars in a bar chart or on the line itself in a line chart. You'll see small circles appear at the data points, confirming the entire series is selected.
2. Right-Click and Select: Now, right-click on the selected series. A context menu will pop up. At the very bottom of this menu, you’ll find the option "Format Data Series...". Click it.

That's it! The Format Data Series pane will slide open on the right side of your Excel window, ready for you to start customizing.

Method 2: The Speedy Double-Click

If you thought the right-click method was easy, this one is even faster. It skips the context menu altogether, taking you directly where you need to go.

Step-by-Step Instructions:

1. Locate Your Data Series: Find the line, bar, or pie slice you wish to edit within your chart.
2. Double-Click It: Simply double-click on any element of that data series.

Excel will immediately open the Format Data Series pane on the right-hand side. This is often the quickest way to jump straight into editing and is a favorite trick of frequent Excel users.

Method 3: Using the Excel Ribbon

Sometimes a chart can be crowded, with multiple overlapping data series or very thin lines that are difficult to click accurately. In these cases, using the Excel Ribbon is a more reliable way to select and format the exact series you need.

Step-by-Step Instructions:

1. Select the Chart: Click anywhere on your chart to select it. When you do this, two new tabs will appear in the top ribbon: "Chart Design" and "Format."
2. Navigate to the Format Tab: Click on the "Format" tab to open its options.
3. Use the "Current Selection" Dropdown: On the far left of the Format ribbon, you'll see a group called "Current Selection." This group contains a dropdown menu that lists every single element of your chart - the title, the axes, the legend, and, most importantly, all of your data series.
4. Choose Your Series: Click the dropdown and select the specific data series you want to edit (e.g., "Series '2023 Sales'"). The series will now be selected in the chart itself.
5. Click "Format Selection": Just below that dropdown menu is a button labeled "Format Selection." Click it, and the Format Data Series pane will appear on the right, specific to the series you just selected.

This method feels a bit more formal, but it’s incredibly precise and a lifesaver for complex charts where clicking the right element is a challenge.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 4: The Power User's Keyboard Shortcut (Ctrl+1)

For those who love to keep their hands on the keyboard and work as efficiently as possible, this shortcut is a must-know. The Ctrl+1 (or Cmd+1 on Mac) shortcut is Excel’s universal command for "Open Formatting Options."

Step-by-Step Instructions:

1. Select the Data Series: First, single-click the data series within your chart that you want to format.
2. Press the Shortcut: With the series still selected, press Ctrl + 1 on your keyboard.

Like magic, the Format Data Series pane will instantly appear. This shortcut works for almost any element in Excel you want to format, including cells, shapes, chart titles, and axes, making it an invaluable tool to add to your skillset.

Inside the Format Data Series Pane: A Quick Tour

Once you've opened the pane, you'll see three main icons at the top that lead to different groups of settings. Here’s a brief breakdown of what you can do in each section.

Fill & Line (The Paint Bucket Icon)

This is where you control the visual appearance of your series. The options will change slightly based on your chart type.

• For Bar/Column/Pie Charts: You'll focus on the "Fill" and "Border" options. You can change the fill to a solid color (goodbye, default blue!), a gradient, or even a picture or pattern. The "Border" option lets you control the color and thickness of the outline around each bar or slice.
• For Line/Scatter Charts: You'll see "Line" and "Marker" options. Under "Line," you can change the color, width, crispness, and style (e.g., solid, dashed, dotted). Under "Marker," you can customize the individual data points on the line, changing their shape (circle, square, diamond), size, fill, and border color.

Effects (The Pentagon Icon)

This section allows you to add a bit of flair to your charts with visual effects like shadows, glows, soft edges, and 3-D formatting. A word of caution: use these sparingly. While a subtle shadow can make bars pop, too many effects can make a chart look dated and unprofessional. In most business settings, clean and simple is best.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Series Options (The Bar Chart Icon)

This is arguably the most powerful section, as it affects the structure and layout of your data series. The key settings here include:

• Plot Series On: This lets you choose between the "Primary Axis" and "Secondary Axis." This is essential when charting two different data types with vastly different scales on the same chart (e.g., plotting sales revenue in millions of dollars and unit sales in the hundreds). Assigning one series to the secondary axis creates a second Y-axis on the right side of the chart, allowing both data sets to be clearly visible.
• Series Overlap (Bar/Column Charts): This controls how much the bars of different series overlap. Setting it to 0% places them side-by-side. A negative value creates a gap between them, while a positive value makes them overlap, which can be useful for comparing actuals vs. targets.
• Gap Width (Bar/Column Charts): This controls the amount of white space between each category grouping. Decreasing the gap width makes the columns thicker and more prominent, which can significantly improve a chart's visual impact. A good starting point is often around 80-100%.

Final Thoughts

Mastering how to find and use the Format Data Series pane is a fundamental step toward creating clear and compelling dashboards in Excel. Whether you prefer the quick double-click, the precision of the ribbon, or a speedy keyboard shortcut, you now have multiple ways to take full control over your chart's design.

Of course, building and formatting charts is often just one small, manual step in a much longer reporting cycle. Instead of constantly exporting data, creating pivot tables, and tweaking chart designs, what if you could just describe the report you need and have it built for you? We built Graphed to automate that entire workflow. You can connect your data sources like Google Analytics, Shopify, and Salesforce, and then create entire dashboards in seconds using simple, natural language. It's like having a data analyst on your team, giving you back hours of your week.