Excel 2003 Graphs

[Mac]

I have pie charts with percentages but not on the Bar graphs.

How can I add the percentage to my Pivot Table bar graph of data?
Is it possible to add additional data from another column to my graph?

I will provide a screenshot in a word.doc to whomever responds so you
can have a visual of what I'm talking about. I know that it is hard at
times to picture what exactly I'm talking about.

Thanks,
M.

 

[Joel]

To add multiple columns, right click graph and chjoose Source Data. On the
Source Data Tab in the Value box seperate the two columns with a comma like
shown below.

=(Sheet1!$B$1:$B$5,Sheet1!$K$1:$K$5)


To show the data values in the graph again right click Graph and Select Cart
Options. then choose Data Labels and click Value box.

 

[Mac]

Thanks for the quick response...

I tried to follow the steps but the SOURCE is greyed out on my Pivot Table.
I tried 1 of the other simple graphs and the SOURCE is available.

What the steps to add a column on a Pivot Tabled graph?

Do I need to add another graph with just that 1 column of data and add a 2nd
column?

p.s.: I'm a newbie to pivot tables. The graphs looks great in comparison
to the normal graphs of raw data. Wow!!!