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.

 Column Chart Conditional Formatting
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Column Chart Conditional Formatting

#1
June 2nd 10, 06:42 PM posted to microsoft.public.excel.charting
 external usenet poster 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
 Luke M[_4_] external usenet poster 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(B2>A2,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
 AlPano 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

 Thread Tools Display Modes Linear Mode

 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 On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 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 04:33 AM.