How to Format Data Series in Excel on Mac

You’ve wrangled the numbers and created a chart in Excel on your Mac, but it looks a bit… generic. Taking that default chart and turning it into a clear, professional-looking visual is the key to telling a compelling story with your data. This guide will walk you through exactly how to format a data series in Excel for Mac, transforming your charts from basic to brilliant.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is a Data Series, Anyway?

Before we start clicking buttons, let’s quickly define what a "data series" is. It's simply a group of related data points that you've plotted on your chart. In your spreadsheet, this is usually a single row or column of numbers. In your chart, it translates to:

• The set of blue bars in a column chart representing Q1 sales.
• The single, squiggly line in a line chart showing website traffic over time.
• The collection of slices that make up a pie chart.

Formatting the data series means customizing the appearance of those bars, lines, and slices to make them easier to read and understand.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Accessing the Format Data Series Pane

The control center for all your formatting is the Format Data Series pane. Getting to it is simple, and once you know where it is, you’ll use it constantly.

1. First, click on your chart to select it.
2. Next, click directly on one of the data series elements you want to change - like one of the bars in a bar chart or the main line in a line chart. Be careful to select the whole series (all the bars will be highlighted) and not just a single point.
3. Right-click (or Control-click) on the selected series.
4. From the dropdown menu, choose Format Data Series...

A new pane will slide out from the right side of your screen. This is where all the magic happens. This pane has three main tabs, usually represented by icons: a paint bucket (Fill & Line), a pentagon (Effects), and a bar chart (Series Options).

Core Formatting Options You'll Use Constantly

Let's break down the most common and impactful changes you can make from the Format Data Series pane.

1. Changing Fill & Colors

This is the most obvious and frequently used formatting option. Bland default colors can make your chart forgettable. Customizing them helps align the chart with your brand or highlight specific information.

Select the Fill & Line tab (the paint bucket icon).

• Fill: This controls the main color of your bars, areas, or pie slices. You can choose a Solid fill and pick a specific color, a Gradient fill for a faded effect, or even a Picture or texture fill to get really creative (though use this one sparingly). For most professional charts, a solid fill is your best bet.
• Border: This controls the outline of your data series elements. You can change the border's color, width, transparency, and style (e.g., solid, dashed, dotted). Adding a subtle, dark border can often make chart elements pop and look cleaner.

2. Adjusting Gaps and Overlaps (for Bar/Column Charts)

This setting, found under the Series Options tab (the bar chart icon), has a huge impact on the readability of your bar and column charts.

• Series Overlap: This option controls how much different series overlap each other. At 0%, the bars from different series will sit side-by-side. A negative value will create a gap between them, while a positive value will make them overlap. This is useful for comparing closely related data sets.
• Gap Width: This controls the amount of empty space between your categories. A smaller percentage creates thick, bold bars, while a larger percentage results in thin, spaced-out bars. Reducing the gap width slightly (e.g., to 100-150%) can often make your chart look more substantial and professional.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

3. Customizing Lines and Markers (for Line & Scatter Charts)

For line or scatter plot charts, the options under the Fill & Line tab look a bit different. You’ll have separate controls for the line itself and for the individual markers (the dots or squares on the line).

Line Options:

• Color & Width: Easily change the line’s color to fit your theme and adjust its thickness (width).
• Dash type: Switch from a solid line to various dashed or dotted styles. This is incredibly useful for differentiating between multiple lines without relying solely on color.
• Smoothed line: Check this box at the bottom to convert your jagged, angular line into a smooth, flowing curve.

Marker Options:

• Markers are the specific points on your line. Excel often adds them by default, but you have full control over their appearance.
• Marker Options: Here you can change the shape (circle, square, diamond, etc.) and size of the markers. You can even choose "None" to remove them for a cleaner, minimalist look.
• Fill & Border: Just like with bars, you can independently control the interior color (Fill) and the outline (Border) of your markers. Matching the marker fill color to the line color is a standard practice that looks clean.

Advanced Tip: Formatting a Single Data Point

What if you want to highlight a single, specific result - like your best-ever sales month or a major dip in traffic? You can format just one data point differently from the rest of its series.

1. Click once on the data series to select all the points (e.g., all the bars).
2. Pause for a second, then click again on the specific bar, point, or pie slice you want to isolate.
3. You'll see that only that single point is now selected.
4. Now, use the Format pane to change its color or add a border. This is the single best way to draw your audience's eye directly to the most important part of the chart.

Saving Time with Chart Styles and Templates

After you’ve perfected a chart, you probably don't want to repeat the entire process every time. Excel provides a few shortcuts.

Using Chart Styles

The quickest way to change your chart's look is with predefined Chart Styles. When your chart is selected, two tabs appear on the Ribbon: Chart Design and Format.

On the Chart Design tab, you'll see a gallery of different styles that bundle colors, effects, and layouts. These are a great starting point, though you'll often want to tweak them further using the Format Data Series pane for a custom look.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Creating a Chart Template

If you have a set of formatting rules you want to apply to charts consistently (e.g., using company brand colors), save your work as a template.

1. Format a chart exactly how you want it.
2. Right-click on the chart and select Save as Template...
3. Give it a name. Excel saves it to a special folder.
4. The next time you make a chart, go to the Chart Design tab > Change Chart Type. In the dialog box that appears, you’ll see a folder called Templates. Your saved design will be there, ready to apply with one click.

Final Thoughts

Formatting a data series in Excel on your Mac is all about making intentional choices to guide your audience's attention. By moving beyond the default settings, you can turn a simple chart into a powerful tool for communication, highlighting trends and insights for anyone to understand.

While mastering these Excel skills is incredibly useful, we know that getting charts to look just right is often part of a much bigger, more time-consuming reporting process. That's why we built Graphed. Instead of manually exporting CSVs and formatting every chart, you simply connect your data sources (like Google Analytics, Shopify, or ads platforms) and describe the dashboard you need in plain English. Graphed automatically generates professional, real-time dashboards for you in seconds, saving you hours of manual work and letting you focus on the insights, not the formatting.