Hi,

Have a look at Jon's page for conditional charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

ivy_gayle wrote:
Can I change data markers so that it reflects the conditional formatting on
that cell? For example if the data in column c is being plotted and the
conditional formatting I have on the cells are if column D = "Y" can I have
it so that those markers are plotted with a circle marker and the rest with a
square marker? Thanks!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info