Radar chart from pivot gives stacked series?

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
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sideways stacked bar charts with line series on the same axis 0
Multiple charts from Pivot Table 0
Stacked Bar Chart 1
Remove series from Pivot Chart 2
Remove series from pivot chart 1
Chart SERIES OFFSET 5
consolidate charts from multiple pivot tables 0
Convert Error Bars to Series and Colour 1

Top