How can I get the chart colours the same as the cell colours autom

[Tony123]

I have highlighted cells in a certain colours based on their values. When I
create a chart I want the bars on the graph to be the same colour as the
cells.

 

[Echo S]

I have highlighted cells in a certain colours based on their values. When I
create a chart I want the bars on the graph to be the same colour as the
cells.

You might want to post this in one of the Excel groups (assuming, of course,
your question is about Excel.)

http://www.microsoft.com/office/com...?dg=microsoft.public.excel.misc&lang=en&cr=US