Excel 2003 Graphs
 

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.

Excel 2003 Graphs
 

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" wrote:

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.

Excel 2003 Graphs
 

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!!!

"Joel" wrote:

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" wrote:

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.