View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Multi axis chart

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/200...column-charts/

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"greyski" wrote in message
...
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