If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel PivotCHarts
How do I convert a pivot table to a pivot chart
|
#2
|
|||
|
|||
Excel PivotCHarts
My colleague Debra Dalgleish has posted this tutorial on my web site:
http://www.geocities.com/jonpeltier/...ivotcharts.htm IMHO, pivot charts are a great idea whose time hasn't yet come. There is a limited choice of chart types, the chart can be formatted only in limited ways (you can't change the PLOT AREA!), the whole pivot table must be included, and whatever formatting you may have applied is obliterated when the pivot table is updated. I generally make regular charts from pivot table data. In Excel 97, which I still use at work, it's no big deal, since '97 has no pivot charts. In later versions, you have to select a blank cell away from the pivot table before you start the chart wizard, then select the ranges on the Series tab of the Source Data form (step 2 of the wizard), one series at a time. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ John Smith wrote: How do I convert a pivot table to a pivot chart |
Thread Tools | |
Display Modes | |
|
|