A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Column Chart Conditional Formatting



 
 
Thread Tools Display Modes
  #1  
Old June 2nd, 2010, 06:42 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 138
Default Column Chart Conditional Formatting

I have a column chart that compares 2 y values against a common x value. I
want to compare the second y value to the first, if it is greater then make
that bar green, if less then red, if same grey. Any ideas on how to go about
this?

Thanks

Adam Bush
Ads
  #2  
Old June 2nd, 2010, 09:00 PM posted to microsoft.public.excel.charting
Luke M[_4_]
external usenet poster
 
Posts: 451
Default Column Chart Conditional Formatting

You'll need to do this by manipulating the actual data.

Setup 3 dummy series, first with a static value of 10. On the chart, format
these green, red, and grey respectively. Now, go back and change the static
values to formulas similar to this:

=IF(B2A2,B2,NA())

=IF(B2A2,B2,NA())

=IF(B2=A2,B2,NA())

If your chart has a legend, you can remove the dummy series by
single-clicking twice on the entry, and then press delete.

--
Best Regards,

Luke M
"
m wrote in message
...
I have a column chart that compares 2 y values against a common x value. I
want to compare the second y value to the first, if it is greater then
make
that bar green, if less then red, if same grey. Any ideas on how to go
about
this?

Thanks

Adam Bush



  #3  
Old July 15th, 2010, 10:06 AM
elliott.matthew elliott.matthew is offline
Member
 
First recorded activity by OfficeFrustration: Jul 2010
Posts: 4
Default

Quote:
Originally Posted by Luke M[_4_] View Post
You'll need to do this by manipulating the actual data.

Setup 3 dummy series, first with a static value of 10. On the chart, format
these green, red, and grey respectively. Now, go back and change the static
values to formulas similar to this:

=IF(B2A2,B2,NA())

=IF(B2A2,B2,NA())

=IF(B2=A2,B2,NA())

If your chart has a legend, you can remove the dummy series by
single-clicking twice on the entry, and then press delete.

--
Best Regards,

Luke M
"
wrote in message
...
I have a column chart that compares 2 y values against a common x value. I
want to compare the second y value to the first, if it is greater then
make
that bar green, if less then red, if same grey. Any ideas on how to go
about
this?

Thanks

Adam Bush
Great and informative information provides here with and I want add the step could easily be incorporated into a macro, but the real focus of this technique is setting up the conditional formatting.And useful and easy to utilise also .
 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:52 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.