creating bar graph

[Shareel]

Hello,

I would like to create a bar-graph using the below data's.

---------------------------------------------
Avg. Temp Low Normal High |
---------------------------------------------
Jan 45.5 25 35 45 |
Feb 28.6 18 25 35 |
Mar 47.3 27 36 48 |
April 51.4 31 39 51 |
---------------------------------------------

Conditions:
1) If the Avg. Temp is below the "Low" value , bar colour should
indicate in Yellow.
2) If the Avg. Temp is Below the "Normal" and above the "Low" it
should indicate colour in Green
3) And if it is above the "High" value should be in Red colour.

Please, anyone can help me to create program for this.


Kind Regards,
Shareel

 

[Andy Pope]

Hi Shareel,

Take a look at Jon Peltier's examples.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

You will need to adapted the technique slightly as you has a different
set of conditions for each row on data.

Cheers
Andy

 

[Shareel]

Thank you so much Mr. Andy Pope,

My problem solved , its almost same like mine.

regards,
shareel