Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
simcol
 
Posts: n/a
Default Stacked column charts


I am interested in presenting 4 different data series as two stacked
columns (i.e. each column stack comprises two data series) side by
side for each x-value on the one chart. Excel is only allowing me to
make one stacked column comprising all 4 data series.

Does anybody know how this can be done?


--
simcol
------------------------------------------------------------------------
simcol's Profile: http://www.excelforum.com/member.php...o&userid=31294
View this thread: http://www.excelforum.com/showthread...hreadid=509672

  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Stacked column charts

The links on this page explain how to create a clustered-stacked column
chart.

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

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


"simcol" wrote in
message ...

I am interested in presenting 4 different data series as two stacked
columns (i.e. each column stack comprises two data series) side by
side for each x-value on the one chart. Excel is only allowing me to
make one stacked column comprising all 4 data series.

Does anybody know how this can be done?


--
simcol
------------------------------------------------------------------------
simcol's Profile:
http://www.excelforum.com/member.php...o&userid=31294
View this thread: http://www.excelforum.com/showthread...hreadid=509672



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
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
IF/AND/OR/DATEIF Issue...sorry...long post... EDSTAFF Excel Worksheet Functions 1 November 10th 05 12:28 AM
Column charts with multiple data in each column steve root Charts and Charting in Excel 1 June 22nd 05 05:16 PM
Stacked Charts w/ Vertical Separation Stacey Charts and Charting in Excel 1 June 10th 05 07:35 PM
Stacked column and column combo chart KG Charts and Charting in Excel 5 March 16th 05 02:01 PM


All times are GMT +1. The time now is 02:44 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"