This will switch the dummy series to the secondary axis and you should have 3 axes displayed, but wait, you need more! The one axis we really want, the bar chart vertical axis, is missing: To fix it: select the dummy series line in the chart > Right-click > Change Series Chart Type. You can see the horizontal axis has gone awry and we have the new (Dummy) series in the chart: So all we need to do is get that bar chart into our line chart, align the labels to the line chart and then hide the bars.Ĭopy cells G4:H10 (note row 5 is intentionally blank) > CTRL+C to copy the cells > select the chart > CTRL+V to paste the dummy data into the chart.

Now comes the Sneaky Bar Chart we know that a bar chart has text labels on the vertical axis like this: Note how the vertical axis has 0 to 5, this is because I've used these values to map to the text axis labels as you can see in the Excel workbook if you've downloaded it. xlsx file please ensure your browser doesn't change the file extension on download. Excel for Customer Service Professionalsĭownload the Excel Workbook and follow along.

How to add excel graph axis label