ExcelBanter - Data Markers

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Data Markers (https://www.excelbanter.com/charts-charting-excel/124427-data-markers.html)

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!

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