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
|
|||
|
|||
Radar chart from pivot gives stacked series?
I've created a radar chart from a pivot table. All the values are
fine, but when creating a pivot chart I get strange results. All the series are stacked. The innermost values are correct. The values from the second series are added to the first, and so on. If I copy all the values from the pivot table and paste them on a new sheet (using Paste Special) everything is fine. Is there a special setting for this somewhere? /Sam |
#2
|
|||
|
|||
Radar chart from pivot gives stacked series?
That is extremely strange. There is no way to create a 'stacked
radar' chart through the normal Chart Wizard. The only way to create such a beast is to first create a Stacked Column PivotChart and then change the type to Radar. On the flip side, to create a normal Radar PivotChart, change the chart type to a clustered column. Then, go back and change the chart type to Radar. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I've created a radar chart from a pivot table. All the values are fine, but when creating a pivot chart I get strange results. All the series are stacked. The innermost values are correct. The values from the second series are added to the first, and so on. If I copy all the values from the pivot table and paste them on a new sheet (using Paste Special) everything is fine. Is there a special setting for this somewhere? /Sam |
Thread Tools | |
Display Modes | |
|
|