Bar graph

asramasarma · May 17th, 2002, 12:23 AM

Hai I have to draw a bar chart such that, For each bar the colour should be blue if the highest value is less than 7 Else up to 7 blue and rest should be red.

paelinck · May 17th, 2002, 12:49 AM

You could make a stacked bar chart with two values ranges: one containing the part of each value that is less or equal to 7, and the other containing the rest value. To obtain this, add two colums next to the original values column with the following formulas (assuming the original values are in column B, starting in B2):

Column C (formula for cell C2, to be copied down):
=MIN(B2,7)
Column d (formula for cell D2, to be copied down):
=MAX(B2-C2,0)

Now make a stacked bar chart using the X-values and the values in columns C and D.

Marc

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 17th, 2002, 12:23 AM	#1
asramasarma New Member Join Date: May 2002 Location: India Posts: 10	Hai I have to draw a bar chart such that, For each bar the colour should be blue if the highest value is less than 7 Else up to 7 blue and rest should be red.

May 17th, 2002, 12:49 AM	#2
paelinck Board Regular Join Date: Mar 2002 Location: Leiden, The Netherlands Posts: 68	You could make a stacked bar chart with two values ranges: one containing the part of each value that is less or equal to 7, and the other containing the rest value. To obtain this, add two colums next to the original values column with the following formulas (assuming the original values are in column B, starting in B2): Column C (formula for cell C2, to be copied down): =MIN(B2,7) Column d (formula for cell D2, to be copied down): =MAX(B2-C2,0) Now make a stacked bar chart using the X-values and the values in columns C and D. Marc