Pivot Chart Inaccuracy

[liquidmettle]

Hi Everyone,

I have a dashboard that uses multiple pivot tables but can't figure out why a few of the bar charts show data in such a misleading way.

For example, the following single bar chart:

PT.JPG

The ratio of those numbers is around 13.5% of the total inspections required but the bar shows it closer to 80-85% complete. Is there a way to get a pivot bar chart to more accurately display the ratio between the bars (I'd like it to show the counts as it does now, but to have the red shaded area more accurately reflect what it should).

Is this possible?

[MrShorty]

I'm sure it is possible, but it is going to be difficult to debug a picture. My first guess is the the numbers given in the data labels are not the same number as what is plotted. The first debugging steps I would likely follow:

1) Select the red bar and identify what range it is pointed to. See what value is being plotted.
2) Select the gray bar and identify what ranges is pointed to. See what value is being plotted.

If either of those values do not match the data label, then figure out why. If they do match, then dig deeper to figure out why they seem so obscured (look at chart type, axis type, and so on).

[romperstomper]

It may also be that one series is plotted on a secondary Y axis with a different scale.