Radar chart from pivot gives stacked series?

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

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
 
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
 
Back
Top