Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Stacked column graph

What data are stacked in the chart, which on top, which on the bottom?

I suspect you need to rearrange your data, and insert spaces to stagger it,
and get the proper arrangement of columns in your chart. One of the links on
this page may be helpful:

http://peltiertech.com/Excel/ChartsH...sterStack.html

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


"Pat" wrote in message
...
I am setting up a stacked column graph. I need to show January 2007 data
next to January 2008, side by side. The data is currently set up as
below:

Jan 07 Jan 08 Feb 07 Feb 08
Label data data data data
Label data data data data

The graph displays all of 2007 together then it shows all of 2008. I need
the months side by side. How do I do this?



--
Pat



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
Creating a graph similar to a stacked column graph Jonathan Charts and Charting in Excel 6 August 4th 06 04:23 PM
How do you combine a stacked column and single column graph? Charlotte C Charts and Charting in Excel 1 December 3rd 05 01:04 PM
How do I set up a clustered stacked column graph? Is it possible? BradT Charts and Charting in Excel 1 October 18th 05 03:30 AM
graph to compare one column with 2 others that are stacked Ellen Excel Discussion (Misc queries) 3 September 21st 05 08:29 PM
How to mix a stacked column and a clustered one on same graph? Armelle Charts and Charting in Excel 1 September 5th 05 01:40 PM


All times are GMT +1. The time now is 02:34 AM.

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"