View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Excel 2003 Graphs

2. Is it possible to add additional data from another column to my
graph?


You cannot add non pivot data to a pivot chart. You can create a regular
chart from pivot data, and add whatever else you need:

http://peltiertech.com/WordPress/200...-pivot-tables/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ty" wrote in message
...
1. How can I add a percentage to my Pivot Table graph of data?

I tried Pivot Table Field--clicked on PivotTable--Show data as:
Percentage-- % Of-- Select Base field--Select Base Item--

It only changed the X-axis from Numbers to 100 % and the graph looks
totally different. I just want a line from the bar showing the label
and a 45 % number. Just like a Pie Chart. I'm stressed out.

2. Is it possible to add additional data from another column to my
graph?

I tried this too to no avail but I will wait on a response.


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,