Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2003 Graphs
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, |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2003 Graphs
Not sure if this is exactly what you want, but to show percentages in
a pivot table, click on the grand total, select Field Settings, Options, Show Data as % of column A Ty wrote: 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Graphs | Excel Worksheet Functions | |||
Excel 2003 Graphs | Excel Discussion (Misc queries) | |||
Transfering Graphs from excel2007 to excel 2003 | Charts and Charting in Excel | |||
Question About Creating Graphs in Excel 2003 | Charts and Charting in Excel | |||
Excel 2003 plotting graphs in inverse order | Charts and Charting in Excel |