Is there a way to do conditional formatting in a data table in charting? For
example,
I want to highlight any negative values, but not the positive. Can
those same volumes also be highlighted or differentiated in some way on the
chart itself?
This is for Excel 2007.

Thanks for any help.

Cindy

Hi,

You have almost no control of data table formatting. I suggest you create
an in spreadsheet data table directly below your chart. Being a range you
can do anything you want to it.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Cindy184" wrote:

Is there a way to do conditional formatting in a data table in charting? For
example,
I want to highlight any negative values, but not the positive. Can
those same volumes also be highlighted or differentiated in some way on the
chart itself?
This is for Excel 2007.

Thanks for any help.

Cindy