Radar chart from pivot gives stacked series?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam - 24 Feb 2004 20:17 GMT

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

Reply to this Message

Tushar Mehta - 27 Feb 2004 16:47 GMT

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.

Signature

Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> 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
[quoted text clipped - 6 lines]
>
> /Sam

Reply to this Message