Line graphs are a popular Excel chart type to visualize trends and changes over time. While the steps are mostly similar across Windows and Mac, there are some differences to be aware of when creating charts on Mac Excel.
- Enter the Data
Create a table with columns for the data categories. The first row should have the labels. Each row represents one data point.
For example:
Year Revenue Expenses
2018 $200,000 $150,000
2019 $250,000 $180,000
2020 $300,000 $200,000- Select the Data
To insert the line chart, you need to first select the data range. This includes the column headers, which will become the legend labels.
You can select by clicking and dragging across the cells.
- Insert Line Chart
Go to Insert > Chart. Or use the Chart button on the toolbar.
In the Charts section, select the Line chart icon. This inserts a basic line chart.
- Modify the Chart
To change the chart style, click the Chart Design tab. Choose the color palette and style you want.
Double click the chart axes to edit the titles and labels.
- Format Data Series
To customize individual data series, click once on the line to select it. Now you can change colors, add data points, and more in the Format pane.
Repeat for other data series.
- Set Axis Bounds
On the Chart Design tab, click Format > Select Data. Adjust the axis bounds in the pop up to zoom the axis scale.
And that’s how you create informative line graphs in Excel for Mac! The process is very similar to Windows.
No products in the cart.