Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
pivot charting doesn't work for me - bill -
I use excel 2002 now but used an earlier version which didn't force me to use
the pivot charting process if I wanted to create graphs. I have my pivot, I click on the graphing icon and the chart appears but I don't have access to source data in the usual excel graphing format other than drop down data on the side or bottom of the pivot chart. Even the data data doesn't list sequentially MONTH (dd/mm/yyyy) 01/04/2007 01/03/2007 01/01/2007 01/02/2007 Is there a way I can disable the pivot chart and use the regular excel charting process? Bill |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
pivot charting doesn't work for me - bill -
You can make a regular chart from a pivot table's data if you're careful
selecting the data. The regular chart will not adjust properly when the pivot table pivots. This article shows how to make pivot charts and regular charts from a pivot table: http://pubs.logicalexpressions.com/P...cle.asp?ID=553 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "billy_bags" wrote in message ... I use excel 2002 now but used an earlier version which didn't force me to use the pivot charting process if I wanted to create graphs. I have my pivot, I click on the graphing icon and the chart appears but I don't have access to source data in the usual excel graphing format other than drop down data on the side or bottom of the pivot chart. Even the data data doesn't list sequentially MONTH (dd/mm/yyyy) 01/04/2007 01/03/2007 01/01/2007 01/02/2007 Is there a way I can disable the pivot chart and use the regular excel charting process? Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel- change the order of a name? Bill Gates to Gates, Bill | Excel Discussion (Misc queries) | |||
Pivot Charting x-axis control | Charts and Charting in Excel | |||
training for Pivot Charting in Excel 2000 | Excel Discussion (Misc queries) | |||
Problem with series when charting from a pivot table | Charts and Charting in Excel |