Yes, it would be nice to be able to do that, but you can't - so I gave you a
couple of workarounds.

Best I can do.

Ed Ferrero


Ed Ferrero,
Thanks for answering my question. What I was looking for was a VB code
that
would change the datatable numbers in a chart if it was less then 93%
I.E.
JAN-100%
FEB-95%
MARCH-92%
In a bar graph with a data table you would see all three but the 92% for
march would be in color red font and the other would be black.
"Ed Ferrero" wrote:

Hi GILBERT,

The easy way is to use a chart embedded in a worksheet, build your own
data
in a worksheet range table below the chart, and use conditional
formatting
to highlight cells below a certain value.

You could also try the technique described here
http://www.edferrero.com/DataTab.zip to link an image of a worksheet
range
to a chart.

Ed Ferrero
Microsoft Excel MVP
http://www.edferrero.com

Could this be done? I've a chart with a data table I need for the
chart
to
highlight only the percentages that are below 93% in red and keep the
higher
percentages with the normal color black...the highlights would be in
the
data table


Thanks In Advance