If you’re an Excel user, you know that a chart or graph is worth a thousand numbers. Visualizing data accurately and effectively is an invaluable skill, but knowing how to add a second axis in Excel can take your data-telling to the next level. Whether you’re new to the world of data visualization or a seasoned veteran, read on to learn how to add a secondary axis in Excel!
Step Right Up and Add a Second Axis in Excel
Adding a second axis to your Excel charts can take your data presentation to a whole new level. It’s easy to do once you know the steps, and the result is a graph that clearly and simply conveys more of your data’s complexity. Here’s how to do it:
- Select the chart and then select the “Design” tab.
- Click “Change Chart Type” and choose a chart type that includes two Y-axes, such as a “Clustered Column – Line on Secondary Axis”.
- Select the data series that you want to plot on the secondary Y-axis.
- Right click and select “Format Data Series”.
- Under the “Axis” tab, select the “Secondary Axis” radio button.
Let the Graphs Do the Talking!
Now that you know how to add a secondary axis in Excel, the power of visualizing data through graphs and charts is yours! Combining different chart types to show more than one set of data within the same graph can be a great way to illustrate correlations and trends. With a few clicks, Excel lets you show the story within your data in a way that words can’t.
Data visualization with Excel graphs is a powerful tool for conveying information quickly and simply. Adding a second axis to your Excel charts is a great way to take your data story-telling to the next level. So, what are you waiting for? Get out there and add a second axis to your Excel charts today!