I have created a bar chart for my manager which he is quite happy with, but
now I have been asked whether it is at all possible to apply a colour to each
bar depending on whether it is equal to certain criteria, a bit like the
conditional format facility. I am currently using Excel 2002. The criteria I
want to use is if the figure is 8.7 I would like the bar in the chart to be
red. 8.3<8.7 orange, 7.8<8.2 yellow and 7.7 or less green. I would also
like these figures to appear in an appropriate coloured square in the legend.
TIA

This page explains how to set up a conditional chart:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Chris waller" wrote in message
...
I have created a bar chart for my manager which he is quite happy with, but
now I have been asked whether it is at all possible to apply a colour to
each
bar depending on whether it is equal to certain criteria, a bit like the
conditional format facility. I am currently using Excel 2002. The criteria
I
want to use is if the figure is 8.7 I would like the bar in the chart to
be
red. 8.3<8.7 orange, 7.8<8.2 yellow and 7.7 or less green. I would also
like these figures to appear in an appropriate coloured square in the
legend.
TIA

Jon,

Thanks that was just what I needed. I do just have one question. I have
recreated my graph from scratch, but unfortunately the #N/As appear on my
chart. Can you let me know how to get around this?

"Jon Peltier" wrote:

This page explains how to set up a conditional chart:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Chris waller" wrote in message
...
I have created a bar chart for my manager which he is quite happy with, but
now I have been asked whether it is at all possible to apply a colour to
each
bar depending on whether it is equal to certain criteria, a bit like the
conditional format facility. I am currently using Excel 2002. The criteria
I
want to use is if the figure is 8.7 I would like the bar in the chart to
be
red. 8.3<8.7 orange, 7.8<8.2 yellow and 7.7 or less green. I would also
like these figures to appear in an appropriate coloured square in the
legend.
TIA

In a column or bar chart, you can use "" in place of NA() in the source
data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Chris waller" wrote in message
...
Jon,

Thanks that was just what I needed. I do just have one question. I have
recreated my graph from scratch, but unfortunately the #N/As appear on my
chart. Can you let me know how to get around this?

"Jon Peltier" wrote:

This page explains how to set up a conditional chart:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Chris waller" wrote in message
...
I have created a bar chart for my manager which he is quite happy with,
but
now I have been asked whether it is at all possible to apply a colour
to
each
bar depending on whether it is equal to certain criteria, a bit like
the
conditional format facility. I am currently using Excel 2002. The
criteria
I
want to use is if the figure is 8.7 I would like the bar in the chart
to
be
red. 8.3<8.7 orange, 7.8<8.2 yellow and 7.7 or less green. I would
also
like these figures to appear in an appropriate coloured square in the
legend.
TIA