Remember Me?

#1
June 2nd 10, 06:42 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 168
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

#2
June 2nd 10, 09:00 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Feb 2010 Posts: 457
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
this?

Thanks

#3
June 19th 12, 04:54 PM
 Junior Member First recorded activity by ExcelBanter: Jun 2012 Posts: 3

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 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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post jsharper Excel Worksheet Functions 2 September 7th 09 10:42 PM Nikhil Charts and Charting in Excel 0 May 22nd 09 04:51 PM Amanda Excel Discussion (Misc queries) 8 June 10th 08 03:23 PM shamor Excel Discussion (Misc queries) 8 May 19th 08 10:11 PM rrupp Excel Worksheet Functions 1 August 23rd 05 10:06 PM

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

The comments are property of their posters.