Pivot Chart Data as Percentage of P-Table column total

J

JohnW

Hi,

I'm struggling because I can't get the percentages of the column total from
my Pivot Table to show up on the related form Pivot chart.

The form is based on a query which has a Count field.
I can design the chart to show the total count in each chart Category.
I can create a new column in the Pivot Table and change the count value into
a Percentage of the Column Total.
Do you know how I can have the chart columns scale up with these percentages
from the Pivot table?

Hope you can help. Thanks in advance.

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
How to display zero value in blank fields of Cross Tab query 0
Dates In Excel 5
Filtered view of Visio Chart 0
Create a chart from a table in word thats dynamic 0
Excel does not accept text format! 0
Pivot table 0

Top