Can I use 2 different Columns of Data for the same axis & same series in Excel

Question

I have a simple dataset in Excel showing Players, Win Count & Win %

I'd like on my Bar Chart to keep the % on the Vertical Axis like it currently... But I'd also like to put the Win Count on the bar chart to annotate each Column. Something like this.

Answer 1

Option 1: Use a second "hidden" series

This is possible by including the Wins column as a second series in the chart and hide it like so:

• Add a secondary vertical axis for the Wins series.
• Format the secondary axis and chose a font color to match the color of your background and also hide its vertical line (so it appears there is no secondary axis).
• Now you can add data labels to the Wins series that show the value of the series on top of the bars.

This works because the relative height of the bars is the same for the Wins and Win % columns. So while it looks like you are displaying only the data for Win %, you are actually showing the data for Wins on top of it. From the legend you will want to delete the hidden series, as it would otherwise give away there being two series in the dataset.

This is what the resulting chart looks like:

Option 2: Manually edit the data labels

If you only create the chart once and its underlying data doesn't change, there is also a simpler option. After adding data labels to the Win % series, you can just click the labels twice (two single clicks, not a double click) and enter a formaula for each.