Conditional Formatting in data table of a chart

G

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

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
 
G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top