Excel Mac Chart Creation: Make and Format Charts

To create a chart in Excel for Mac, select your data, choose Insert > Recommended Charts, select a chart type, and click OK. Then use the Chart Design and Format tabs to add a title, adjust labels, and refine the chart so readers can understand the data quickly.

Quick steps to create a chart on Mac

Excel places a new chart on the worksheet by default, where you can move or resize it. These steps apply to current Microsoft 365 versions of Excel for Mac; names or button locations can vary slightly in older releases.

Arrange the data in a simple table. Put category labels in the first column or row, and include a heading for each numeric series.
Select the entire range, including its headings. For example, select the month labels and the corresponding sales figures together.
On the ribbon, choose Insert > Recommended Charts. Review the suggested charts, or open the chart-type options to see more choices.
Select a chart and choose OK. Excel inserts it into the worksheet.
Select the chart to reveal the chart-specific ribbon tabs. Use Chart Design to change its type, layout, colors, or data source, and Format to adjust selected chart elements.

If you already know what chart you need, choose a chart type directly from the chart options on the Insert tab instead of reviewing recommendations. To place the chart on its own sheet rather than beside the source data, select the chart and look for Chart Design > Move Chart. An embedded chart is usually more convenient when the chart belongs beside a table or notes.

Prepare the worksheet data first

A chart is only as clear as the range behind it. Give each column or row a descriptive heading, keep each series in a consistent unit, and avoid blank rows or columns inside the data block. A layout such as Month, Product A, and Product B in the first row, followed by one month per row, makes it easier for Excel to identify the series and category labels.

For example, if a table has months in column A and sales for two products in columns B and C, select the headings and all three columns of values. Excel can then use the months as the horizontal category labels and create one series for each product. If the chart shows months as separate series instead, select Chart Design > Switch Row/Column. This changes how Excel interprets the selected range without changing the worksheet data.

Use real dates or numbers when the information represents dates or quantities; text that merely looks like a number may not behave as expected.
Keep units consistent within a series. Mixing dollars and percentages on one axis can make comparisons misleading.
Use a clear label for every series. Generic headings such as Column 1 are less useful in a legend.
Exclude totals from the chart range if they would distort comparisons between the individual categories.

When a table has several rows of headings, merged cells, or notes mixed into the data, Excel may guess the range incorrectly. A clean rectangular range is a better starting point than trying to correct a complicated chart afterward.

Choose a chart type that fits the question

Choose a chart based on what the reader needs to compare, not simply on appearance. A familiar chart often communicates a result more clearly than a decorative one.

Column or bar: Compare amounts across categories, such as sales by product or responses by department. Bar charts are useful when category names are long.
Line: Show a pattern over an ordered sequence, particularly change over time. A line chart is a natural choice for monthly readings or annual totals.
Scatter (X, Y): Explore the relationship between two numeric variables, such as advertising spend and sales. Unlike a basic line chart, a scatter chart uses numeric values on both axes.
Pie or doughnut: Show parts of a whole when there are only a few categories and they add up to a meaningful total. Many small slices are difficult to compare; a bar chart is often clearer.
Area: Emphasize how totals or quantities change over time. Overlapping filled series can obscure one another, so use this type carefully when there are several groups.

Excel’s Recommended Charts can help when the best option is not obvious, but a recommendation is not a guarantee that the chart suits the question. Check that the axes, labels, and series match the story you intend to tell. For instance, a line chart may imply a continuous progression between categories that are actually unrelated.

Format titles, axes, legends, and labels

Select the chart, then use Chart Design > Add Chart Element to add items such as a chart title, axis titles, data labels, or gridlines. The exact available elements depend on the chart type. Click a title in the chart to edit its text, and make the wording specific: Revenue by Quarter is more informative than Sales Chart.

Use the legend when readers need to distinguish multiple series. If there is only one series and its meaning is obvious from a direct title or labels, the legend may take up space without adding much. Data labels can help readers see exact values, but labeling every point in a crowded chart can make it harder to read. Use them selectively.

To change an axis, select it and open its formatting options. You can adjust details such as number display, bounds, and tick marks where those options are available. Be cautious about changing the vertical axis minimum: starting a bar chart at a value other than zero can exaggerate differences in bar height. For a line chart, a narrowed scale can be useful for examining small changes, but label the scale clearly and consider whether the presentation could mislead.

Chart Design also offers chart styles and color choices. Prefer strong contrast and a restrained palette, especially when several series appear together. A chart should remain understandable in grayscale or for readers who have difficulty distinguishing certain colors; labels, markers, or line styles can provide additional cues.

Update the source range and keep charts current

If a chart omits rows or includes the wrong cells, select it and choose Chart Design > Select Data. In the data-source controls, review the chart range and the individual series and category labels. Correcting the source range is usually better than rebuilding the chart when the original selection was slightly wrong.

A chart based on a fixed cell range may not include rows added below that range later. One way to make regularly growing data easier to manage is to format the source range as an Excel table using Home > Format as Table. Charts based on table data can use the table as their source, so adding data to the table can extend the chart range. Check the result after adding rows, particularly if the new data is entered outside the table or the chart has unusual settings.

Changes to existing values in the source cells normally appear in the chart automatically. If the chart seems stale, check whether the plotted range points to the intended cells and whether the workbook is using automatic calculation. Also confirm that the new values are numeric rather than text; text values may be omitted or treated differently from the numbers you expected.

Use multiple series and combination charts thoughtfully

Two series can make a comparison useful, but series with very different scales may be hard to see together. For example, monthly revenue in thousands and a customer satisfaction rate from 0 to 100 are not directly comparable on one vertical scale. A combination chart can show different measures with different chart types, and Excel can place a series on a secondary axis when that is appropriate.

To explore that option, select the chart and use Chart Design > Change Chart Type, then choose a combination setup if it is offered for the selected data. Set the chart type for each series and use a secondary axis for the series whose scale requires it. Review both axes carefully and label them with units. A secondary axis can reveal patterns, but it can also make unrelated measures appear to move together; explain what each axis represents rather than relying on color alone.

If Excel has interpreted rows and columns in the wrong direction, try Chart Design > Switch Row/Column before changing individual series. For more control, open Select Data and inspect each series name, values, and category labels. This is especially helpful when charting non-adjacent data or a table with several series.

Common chart problems on Excel for Mac

The chart is blank or missing points: Check that the selected range includes numeric values and that cells do not contain numbers stored as text. Inspect hidden or filtered rows if relevant, and verify the chart’s source range.
Excel uses the wrong labels: Select the chart and use Switch Row/Column, or open Select Data to check the category-label range and series definitions.
Dates appear as separate categories or odd values: Confirm that the worksheet cells contain actual Excel dates, not inconsistent text entries. Use a line or date-based axis when the time intervals matter.
The title or legend is missing: Select the chart and add the relevant element through Chart Design > Add Chart Element. Some chart types do not use every element.
New rows do not appear: Check whether the chart uses a fixed range and whether the added data is inside the source table or range. Adjust the source through Select Data if needed.

Excel for Mac has ribbon tabs and chart-formatting controls that may look different from screenshots made on Windows, but the core workflow is similar. If a command seems absent, first select the chart: chart-specific tabs are contextual and generally appear only while the chart is selected. The ribbon can also be collapsed, which hides commands until it is expanded.

Move, copy, and share a finished chart

To reposition an embedded chart, select its outer border and drag it. Drag a corner sizing handle to resize it while keeping its proportions more consistent than dragging a side handle. To put it on a separate chart sheet, use Chart Design > Move Chart if that command is available in your Excel build. A separate sheet can be useful for presenting one large chart, while an embedded chart keeps the source table close at hand.

You can copy a chart into another worksheet or an Office document, but consider how the pasted chart will be used. A chart pasted as an image is easy to place but no longer updates from the workbook data. A chart pasted with a link can reflect later changes, but the link depends on the source workbook remaining available. For a workbook that others will edit, keep the chart and its data together and use descriptive worksheet names.

Before sharing, check that the chart has a meaningful title, readable text, clear units, and a visible explanation for each series. Do not rely on color alone to convey a critical distinction. A brief note near the chart can clarify an unusual scale, a missing-data period, or why a secondary axis is used.

Frequently Asked Questions

How do I make a chart in Excel on a Mac?
Select the data, choose Insert > Recommended Charts, pick a suitable chart, and click OK. Then select the chart to open its Chart Design and Format controls.

How do I add a title to an Excel chart on Mac?
Select the chart and choose Chart Design > Add Chart Element > Chart Title, then click the title and type your text. The available title placements can depend on the chart type and Excel version.

Can I change a chart type after creating it?
Yes. Select the chart and choose Chart Design > Change Chart Type, then choose a different type. Review the result because the new type may interpret categories, series, or axes differently.

Why is my Excel chart not showing all the data?
The chart may use an incomplete source range, or some values may be stored as text. Select the chart, inspect Chart Design > Select Data, and confirm that the intended cells contain valid values.

How do I make an Excel chart update when I add data?
Use an Excel table as the chart source when the dataset will grow, and add new records within the table. If the chart still omits them, inspect its source range and update it through Select Data.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.