Here is a question from Amanda:
I use Excel in order to create a monthly report that contains some bar and scatter charts, all fed from data in another worksheet, once i insert my charts, i have noticed that none of them include axis titles. Any idea how to add those axes labels to the chart and how to automate that process? I am not sure which version of Excel i am using, i believe it’s 2019.
Adding axis title labels to Excel chart
Thanks for the question let’s break down the process into simple steps. We’ll use a simple example of creating an XY chart, but the process is similar for every graph you might be plotting in Excel.
- In Microsoft Excel, select your data and hit Insert, then from the Ribbon pick the scatter chart.
- A simple chart will be rendered.
- Now, go ahead and click on your chart figure external border.
- You’ll notice three buttons popping up at the upper right side of your chart.
- Hit the Chart Elements button (marked with a + sign) as shown below.
- Now, check the box right next to Axis Titles.
- You’ll notice that placeholder for the axis labels, labeled Axis Title will become visible.
- Double click each of the placeholders and modify the name and font properties as needed.
- Optionally – modify the chart title as well.
- Here’s our chart:
Note: You can also easily add data labels to your chart.
Using the Data Analysis assistant in Excel 365
In Excel 365, you are able to leverage the nice Analyze Data capability that allows to automate your chart creation process by analyzing your data and offering possible formatting options that you can later enhance as needed.
Using the Analysis Data is a breeze:
- In your spreadsheet, highlight your data.
- Go to the Home tab.
- In the right side of your Ribbon, hit the Analyze Data button; this will open a pane at the right hand of the screen.
- In the Discover Insights section, you’ll find several charts that might fit your specific needs.
- In our case, there is a predefined XY scatter which is almost ready to, so you can hit the Insert Chart button and add it to your worksheet.
- You can obviously make changes to your pre-generated chart look and feel in the same way as described in the previous section.
- Last, save your workbook.