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
|
|||
|
|||
Remove series from pivot chart
I have a pivot table linked to an OLAP cube with 10 data series and have
created a chart from that data. However, I cannot remove any series from the chart - the "remove" (and all other) buttons are greyed out in the chart. What I need to do is have 3 charts in my sheet, each containg 3 series from my main pivot table. Any way to do that? Thanx |
#2
|
|||
|
|||
Remove series from pivot chart
A pivot chart has to show all the data in the related pivot table, and it
cannot show data from elsewhere. Make yourself a regular chart from the pivot table data. Select a blank cell that's not touching the pivot table, and start the chart wizard. In step 2, select data, click on the Series tab, and add your data one series at a time. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Alexander Caravitis" Alexander wrote in message ... I have a pivot table linked to an OLAP cube with 10 data series and have created a chart from that data. However, I cannot remove any series from the chart - the "remove" (and all other) buttons are greyed out in the chart. What I need to do is have 3 charts in my sheet, each containg 3 series from my main pivot table. Any way to do that? Thanx |
Thread Tools | |
Display Modes | |
|
|