Highlighting in data table

  • Thread starter Thread starter Cindy184
  • Start date Start date
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
 
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.
 
Back
Top