View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
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