Highlighting in data table

C

Cindy184

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
 
S

Shane Devenshire

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.
 
Top