Formatting options for your line graph
This has to be the most fun and interesting part of creating a line graph.
Excel offers a huge variety of formatting options for graphs. You can adjust the chart to your preferences in seconds only using the Format Data Series pane.
Let’s explore some of these formatting options below.
Adding the chart title & axis title
At the top of the graph, you see the heading “Chart Title”.
To add your own Chart Title, simply click on it and a text box will enclose this heading.
In the text box, add any title you think fits the chart.
For example, we have set the chart title as follows:
Now let’s add the Axis title to the same graph. But first, we need to enable the axis titles.
For that, click on the plus icon at the top right of the chart. A drop-down list will appear.
Select the Axis Titles, and a rectangular box will appear on the left and bottom of the chart. The box on the left side is the text box for the Y-axis. And the box on the bottom is the text box for the X-axis.
Add in the title for the X-axis and Y-axis. And the result looks like this:
And there it is🥂
Data labels and markers
You can also select other options in the drop-down list to add elements to your chart. Like inserting Data Labels, Error Bars, Trendlines, and others.
To add data labels to your chart, simply click on the plus sign icon to the right of the chart. And checkmark the option for data labels.
Adding Data Labels looks like this:
See those data labels – $200, $450, $600, and so on alongside the trendline.
Similarly, you can add Markers to your graph from the Format Data Series task pane.
Double-click the trend line on your chart, and the pane will appear on the right side.
Select Series from the drop-down menu.
Go to Marker options > Built-in > Type. Select a shape for the markers, and it will appear on each intersection point on the trendline.
Changing the style, color, and overall look of the chart makes it look twice more appealing. And doing this is not difficult.
Select the chart, and the Chart Design tab will appear at the top of the ribbon.
Clicking the tab will open a plethora of style choices for you. Simply select the one you like.
Hover over the desired style to see a preview of the final look. We chose Style 7, and this is how it turned out 🤩
Similarly, you can change the type of the chart using the Insert Line or Area Chart.
It offers options like the Stacked line graph, Scatter Chart, 100% Stacked line chart, and others. Users mostly use the default line chart to represent their data.
Formatting axis options
The Axis options make the most important part of the Data Series task pane. It lets you change the min and max numeric values for the axis, the line width, and much more💪
For now, let’s see how to change the Bounds and Units for a chart in Excel. For that:
- Go to the Format Data Series Task pane > Axis Options.
- Select the Vertical (value) axis from the drop-down list.
This will show you the present value set for the Bounds and Units.
Say, this is our default setting.
Bounds are set to a Minimum of 0 and a Maximum of 2500. This means that your Y-axis will range from 0 to 2500. Take a look below.
Note that the gap between each axis point is 500. The first point on the Y-axis shows 0, then comes 500, then comes 1000, and so on.
This is because the Units are set to a major of 500.
You can change the Bounds and Units for your chart through the following steps.
- Under the Axis options panel, set the desired values for Bounds and Units.
- Press Enter.
Altering the Bounds value will change the minimum and maximum values on the graph. And Units value will change the gap between the two axis points.
For example, if we were to change the:
- the minimum Bounds to 200 from 0.0;
- and the major Units to 800 from 500:
The Graph will change as follows:
Note how the starting axis point is now 200 and the gap between all axis points is now 800.
The Data Series task pane has a lot more to offer. Like you can change the type of absolute values, change the alignment of the graph, add effects, and do so much more about your graph in Excel 🤩