PC Review


Reply
Thread Tools Rate Thread

Column Chart, Displaying two values on one column.

 
 
brettmanning24@gmail.com
Guest
Posts: n/a
 
      14th Nov 2007
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 With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      14th Nov 2007
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
_______


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007- unwanted column chart n/a labels displaying Bob Arnett Microsoft Excel Charting 3 7th Jul 2008 05:30 PM
Problem displaying Y Axis title on a column chart in powerpoint =?Utf-8?B?U2FuZHJh?= Microsoft Powerpoint 1 15th Nov 2006 04:17 PM
Search for a value in column A and return the vaule/values in column B to column C minismood Microsoft Excel Discussion 3 10th Jan 2006 10:02 AM
Column Chart with 2 values in each column Alec Green Microsoft Excel Charting 2 25th Feb 2005 06:12 AM
Re: Combined columnar chart(3 - 5 columns) and stacked column (1 column, 2 series) as one chart Nicky Microsoft Excel Charting 1 8th Apr 2004 07:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:38 AM.