Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 27
Default Column Chart, Displaying two values on one column.

Hello,

Is it possible to display two value on one column. For example

Budget = 4.6%
Actual = -6.0%

I can display this on a column without any problems, one column for
budget and one for actual. Is it possible to add another value to the
Actual so it displays on the same column but in a different colour?
For example I would like to add:

Net = 2.3% and display this on the Actual column in a different
colour.

Any help would be appreciated.

Thanks,

Brett

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Column Chart, Displaying two values on one column.

You can format a stacked column chart to resemble a clustered-stacked column
chart:

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

Keep in mind that stacking positive and negative items in a column chart
very often does not give the desired result.

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


wrote in message
ups.com...
Hello,

Is it possible to display two value on one column. For example

Budget = 4.6%
Actual = -6.0%

I can display this on a column without any problems, one column for
budget and one for actual. Is it possible to add another value to the
Actual so it displays on the same column but in a different colour?
For example I would like to add:

Net = 2.3% and display this on the Actual column in a different
colour.

Any help would be appreciated.

Thanks,

Brett



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
stacked column chart with negative values maryj Charts and Charting in Excel 5 June 13th 07 07:19 PM
comparing 2 values on one column in chart Carly Charts and Charting in Excel 8 February 1st 07 01:38 AM
Column chart not displaying some data points - Excel 2003 Don Burgess Charts and Charting in Excel 3 November 28th 06 06:20 PM
problems with displaying "duplicate vlookup values" in same column p CAST Excel Discussion (Misc queries) 7 August 7th 06 06:24 PM
Column Chart with 2 values in each column Alec Green Charts and Charting in Excel 2 February 25th 05 06:12 AM


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