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
- 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
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.