Conditional Formatting in data table of a chart

[Guest]

I'm using Excel 2007, and trying to apply conditional formatting to the data
table of a line chart. I've tried creating the chart without the formatting
applied to cells with the original data (data source), and then applying the
format to the source; as well as creating the chart after applying the format
to the source. The data table in the chart will naturally update with
changed data since it is linked, but will not incorporate any style
formatting. Any thought? Thanks.

 

[Jon Peltier]

Data tables in charts are not particularly flexible. They do not, for
example, support conditional formatting. You could make a table in the cells
near the chart, include any data you want in any order, and apply any
formatting you want. This table isn't integrated into the chart's category
axis, but you'll find that's less important than you think.

- Jon

 

[Guest]

Thanks for the response. That was the work-around I came up with once I
moved it to PPT, so that definitely works for me.