#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 12
Default Stacked Bar Graph

I have data from last year that I want to compare with data from this year.
The data is broken into components, so I'd like to use a stacked bar graph to
compare the data by month. Is there a way to put two columns of data next to
each other in a stacked bar graph?

X-Axis would have months (Jan - Dec)
Each month would have two columns - one for 2007, one for 2008

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Stacked Bar Graph

http://peltiertech.com/WordPress/200...column-charts/
http://peltiertech.com/WordPress/200...ed-bar-charts/

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


"tomic" wrote in message
...
I have data from last year that I want to compare with data from this year.
The data is broken into components, so I'd like to use a stacked bar graph
to
compare the data by month. Is there a way to put two columns of data next
to
each other in a stacked bar graph?

X-Axis would have months (Jan - Dec)
Each month would have two columns - one for 2007, one for 2008

Thanks.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stacked bar, bar and line graph JoAnn Charts and Charting in Excel 1 August 8th 08 10:45 PM
Stacked Bar graph Patrick Charts and Charting in Excel 3 June 20th 07 07:26 PM
Cluster stacked graph AND line combo graph? [email protected] Charts and Charting in Excel 6 October 14th 06 12:33 AM
Creating a graph similar to a stacked column graph Jonathan Charts and Charting in Excel 6 August 4th 06 04:23 PM
Stacked Bar graph Pooja Excel Discussion (Misc queries) 6 March 6th 06 03:30 PM


All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"