Add Value Label to Pivot Chart Displayed as Percentage

[jschena]

I have created a pivot chart that "Shows Values As" % of Row Total. This chart displays items that are On-Time vs. items that are Late per month. The chart is a 100% stacked bar. I would like to add data labels for the actual value. Example: If the chart displays 25% late and 75% on-time, I would like to display the values behind those %'s, such as 1 late and 3 on-time. Is there a way to do this? I tried using a secondary axis (invisible line) and couldn't get the labels to display in the correct places.

Thanks!!!!

 

[pbornemeier]

Perhaps something like this: How to use a macro to add labels to data points in an xy scatter chart or in a bubble chart in Excel could be modified to work for your situation.

 

[pbornemeier]

If you use the hidden line method: How to Add Total Data Labels to the Excel Stacked Bar Chart and then use the code mentioned in post #2 to create boxes offset from the hidden line points, you should be able to place the additional labels where you want.