Multi axis chart
 

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

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

Multi axis chart
 

On Wed, 17 Sep 2008, in microsoft.public.excel.charting,
Jon Peltier said:
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

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.