LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Stacked bar chart, Excel 2007

I have 5 columns.

Column A is 1 through 12 for months.

Column B is Dept 1 Budget for each month.
Column C is Dept 2 Budget for each month.

Column D is Dept 1 Actual for each month.
Column E is Dept 2 Actual for each month.

I'm trying to create two stacked bars per month, one of Columns B&C (Budget)
and one of Columns D&E (Actual).

The best I can get is one column per month with all 4 values stacked.

How can I turn this into two columns per month?



--
rsenn
 
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
?make a combo chart with 1 stacked bar and 1 not stacked, + show t y Charts and Charting in Excel 3 March 17th 08 08:22 PM
Combination Column and Stacked Column Chart in XL 2007 Pat R. Charts and Charting in Excel 1 January 26th 08 02:34 PM
How can I combine a stacked bar chart with stacked colum chart? Sin Charts and Charting in Excel 8 December 20th 05 03:50 AM
To create a stacked column chart and group the stacked bars togeth Jacqueline Charts and Charting in Excel 1 February 17th 05 11:05 PM
How can I create a stacked bar chart with stacked bars side by TimMC Charts and Charting in Excel 1 January 22nd 05 02:09 AM


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