As John points out, use worksheet cells to simulate the effect of a
data table. For an introduction, see Custom Chart Table
http://www.tushar-mehta.com/excel/ne...able/index.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article .com,
says...
I've created a chart that is based on a data set where the cells have
conditional formatting (if value a value b then colour the cell red)

I have the data table displayed with the chart (in chart options, 'show
data table' is ticked), but the condtional formatting is not displayed
in this table, i.e cells that are red in my original data set are not
coloured in the chart table.

Is there any way to apply the conditional format on the table displayed
within the chart?

Cheers

Dan.