Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I edit data categorylabels in a multi-level vertical axis? | Charts and Charting in Excel | |||
How to create multi columnar chart with 2 Y axis AND ALONG WITH TR | Charts and Charting in Excel | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
multi-line graph with dates on x-axis | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel |