Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 2nd 10, 06:42 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 168
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

  #2   Report Post  
Old June 2nd 10, 09:00 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2010
Posts: 457
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(B2<A2,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   Report Post  
Old June 19th 12, 04:54 PM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2012
Posts: 3
Default

Hi, you can create a new table as Luke M[_4_] said and then create Stacked Column Chart.
This may help: http://excel-example.com/charts/cond...umn-bar-charts

Quote:
Originally Posted by View Post
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


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
have B column turn red on conditional formatting of E column: jsharper Excel Worksheet Functions 2 September 7th 09 10:42 PM
conditional formatting of columns in a column chart Nikhil Charts and Charting in Excel 0 May 22nd 09 04:51 PM
Conditional Formatting for a Column Chart and Auto Shape Amanda Excel Discussion (Misc queries) 8 June 10th 08 03:23 PM
Formatting cells in a column with conditional formatting? shamor Excel Discussion (Misc queries) 8 May 19th 08 10:11 PM
column to column conditional formatting won't work, need formula rrupp Excel Worksheet Functions 1 August 23rd 05 10:06 PM


All times are GMT +1. The time now is 05:09 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017