Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
peterhall99
 
Posts: n/a
Default how do I create a stacked bar chart on 2 axis

I'd like to create a stacked bar chart showing two stacked bars (Forecast and
Actual), however I can only get excel to produce 1 stacked bar. Is there a
way of displaying two stacked bars side by side?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default how do I create a stacked bar chart on 2 axis

Hi,

See Jon Peltier's page on cluster stacked column chart.
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

peterhall99 wrote:
I'd like to create a stacked bar chart showing two stacked bars (Forecast and
Actual), however I can only get excel to produce 1 stacked bar. Is there a
way of displaying two stacked bars side by side?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Posted to microsoft.public.excel.charting
peterhall99
 
Posts: n/a
Default how do I create a stacked bar chart on 2 axis

Andy,

Many thanks, the link gave me exactly what I was looking for.

Cheers...Peter

"Andy Pope" wrote:

Hi,

See Jon Peltier's page on cluster stacked column chart.
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

peterhall99 wrote:
I'd like to create a stacked bar chart showing two stacked bars (Forecast and
Actual), however I can only get excel to produce 1 stacked bar. Is there a
way of displaying two stacked bars side by side?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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
Combine stacked column and line chart w/series lines ancillaries Charts and Charting in Excel 1 April 7th 06 11:51 PM
Stacked Bar Chart - used for a Tornado Chart [email protected] Charts and Charting in Excel 3 April 5th 06 12:15 PM
How can I create a combination stacked & cluster column chart? fullerdb Charts and Charting in Excel 1 April 3rd 06 06:22 PM
How do I fix my Stacked column chart with grand totals? Jennifer Charts and Charting in Excel 2 February 27th 06 05:20 PM
Create a combo chart with two of the same chart types Mark Parent Charts and Charting in Excel 2 October 14th 05 01:28 AM


All times are GMT +1. The time now is 05:20 PM.

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

About Us

"It's about Microsoft Excel"