Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Conditional columnar graph
I have 2 data points for every store across 2 qtrs.
E.g: Store Qtr1 Qtr 2 StoreX 2.5 5 I want a column graph with the condition that if the Qtr 2 score is higher than Qtr 1, then the column should be green in color and if it is lower than Qtr 1, then it should be red in color. How can i do this? Nikhil |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Conditional columnar graph
Hi,
You can add additional series based on formula. Format Less/Same/Greater columns as required. A1:= B1: =2.5 C1: =5 A2: = B2: =Q1 C2: =Q2 A3: =Store X B3: =B1 C3: = A4: =Less B4: = C4: =IF($C$1<B3,$C$1,NA()) A5: =Same B5: = C5: =IF($C$1=B3,$C$1,NA()) A6: =Greater B6:= C6: =IF($C$1B3,$C$1,NA()) Create a chart based on A2:D6, plot by rows. Set the Overlap to 100. Right click any series and pick Format Series. Overlap property is on the Series Options tab. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Nikhil" wrote in message ... I have 2 data points for every store across 2 qtrs. E.g: Store Qtr1 Qtr 2 StoreX 2.5 5 I want a column graph with the condition that if the Qtr 2 score is higher than Qtr 1, then the column should be green in color and if it is lower than Qtr 1, then it should be red in color. How can i do this? Nikhil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeating columnar data | Excel Worksheet Functions | |||
Do you have an Excel template that looks like a 4-columnar pad? | Excel Discussion (Misc queries) | |||
Columnar Paper Template | Setting up and Configuration of Excel | |||
Green Columnar Template in Excel | Excel Discussion (Misc queries) | |||
list two columnar values based on conditional formating (text color) | Excel Worksheet Functions |