Multi axis chart

[greyski]

Hi, I want to show a stacked chart, ie 4 products sales value in a given
month. But then compare it to the prvious years results.

I know you could use a 3D chart to show 3 axis, however I can't find how to
have the 2 axis (last year and this year) stacked.

Hope you understand what I'm asking

 

[Jon Peltier]

A 3D chart is more likely to obscure than show anything.

I'm not sure what you're looking for. Perhaps a stacked-clustered column
chart, where each column in the cluster has the four stacked values for each
year.

http://peltiertech.com/WordPress/2008/05/19/clustered-stacked-column-charts/

For some reason this is by far my most popular blog entry.

- Jon

 

[Del Cotter]

A 3D chart is more likely to obscure than show anything.

I'm not sure what you're looking for. Perhaps a stacked-clustered column
chart, where each column in the cluster has the four stacked values for each
year.

I was thinking he might like a vertical panel chart

http://peltiertech.com/Excel/Charts/StackedCharts.html