Data Bars - older versions of Excel

[Jeff Barnes]

Hi,

Is it possible to get something like the Data Bars in 2007 in older version of Excel?
I would like to fill a cell with a color based on the value (0 to 100).
So if the value was 50, only half the cell would be colored red.

Also, in Excel 2007 ... when using Data Bars, if the value is zero, there is still some fill being done. Is is possible to have no fill at all if the value is zero?

Thanks,

Jeff

 

[wigi]

To both of your questions, I'm afraid no.

 

[Sandeep Warrier]

Hi,

Is it possible to get something like the Data Bars in 2007 in older version of Excel?
I would like to fill a cell with a color based on the value (0 to 100).
So if the value was 50, only half the cell would be colored red.

Also, in Excel 2007 ... when using Data Bars, if the value is zero, there is still some fill being done. Is is possible to have no fill at all if the value is zero?

Thanks,

Jeff

You can, in practice, create something similar to Data Bars..

See if you can modify this to suit your purpose.

Excel Workbook
	A	B	C
1	Name	Score	Graph
2	ABCD	50	||||||||||||||||||||||||||||||||||||||||||||||||||
3	EFGH	75	|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4	IJKL	68	||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5	MNOP	91	|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sheet1

Excel 2003

Cell Formulas
Range	Formula
C2	=REPT("|",B2)

<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[T. Valko]

You can, in practice, create something similar to Data Bars..

See if you can modify this to suit your purpose.

Excel Workbook
	A	B	C
1	Name	Score	Graph
2	ABCD	50	||||||||||||||||||||||||||||||||||||||||||||||||||
3	EFGH	75	|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4	IJKL	68	||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5	MNOP	91	|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sheet1

Excel 2003

Cell Formulas
Range	Formula
C2	=REPT("|",B2)

<INPUT id=gwProxy type=hidden><!--Session data--><INPUT id=jsProxy type=hidden *******="jsCall();"><INPUT id=gwProxy type=hidden><!--Session data--><INPUT id=jsProxy type=hidden *******="jsCall();">

If you format the cells to use the Webdings font then you can get a "solid" bar with this formula:

=REPT("g",B2)

Of course, you'd want to make the column width proportional to the scale you're using!

Also note, any decimals will be truncated to their integer values: 5.4 = 5, 9.9 = 9, 0.8 = 0.

 

[Sandeep Warrier]

If you format the cells to use the Webdings font then you can get a "solid" bar with this formula:

=REPT("g",B2)

Of course, you'd want to make the column width proportional to the scale you're using!

Also note, any decimals will be truncated to their integer values: 5.4 = 5, 9.9 = 9, 0.8 = 0.

I actually use Alt+219 .... but it didn't come out properly on the HTML maker.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[Jeff Barnes]

Thanks. This just might work for what I need

 

[dave3009]

You could also create the illusion using the camera tool. Create a bar chart and scale it to the size of your cells. Now overlay a snapshot of your data using the camera tool and setting the picture color and lines to none. The downside is that you can click on the number to edit it.

You could experiment with a full block for the REPT functions already provided

Cell Formulas
Range	Formula
J9	=REPT("█", H9)