Column Chart Conditional Formatting

AlPano

Junior Member

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 10:12 AM.

Menu

About Us