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?