Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 10
Default Axis change for stacked and clustered columns

Hi,

I have 4 expense categories that I am comparing prior to budget to actuals
(ie 3 stacked columns). In the same chart, I would like to have the same
setup, but with YTD amounts. I can get it to work, but the problem is that
the YTD values are obviously much larger and I need to get them onto the
second axis - can anyone provide some guidance?!

Mar Prior Mar Budget Mar Actual YTD Prior YTD Budget
YTD Actual
Sal 10 12 15 30
36 45
Occu 5 6 7 15
18 21
Selling 2 2 2 8
6 7
G&A 3 4 4 5
7 9









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
Possible to show clustered and stacked columns on one chart? crochetlady Charts and Charting in Excel 1 April 18th 07 03:34 PM
Stacked/clustered column graph with secondary y axis [email protected] Charts and Charting in Excel 0 March 15th 07 02:57 PM
Stacked AND Clustered AND Different axis scales Álvaro Charts and Charting in Excel 0 November 9th 05 05:04 PM
Create stacked columns chart but with 2 columns for each x axis? PSM Charts and Charting in Excel 2 May 7th 05 03:56 PM
is it possible to build a chart with clustered stacked columns ? Fabio Battagion Charts and Charting in Excel 1 January 27th 05 01:10 PM


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