ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   marker style change for an individual month (https://www.excelbanter.com/charts-charting-excel/110655-marker-style-change-individual-month.html)

JH

marker style change for an individual month
 
Is it possible to change the individual marker style for a particular month
in a line graph in the same way we can do conditional formatting for a cell?
For example I want to show that a month in a line gragh met a specific goal
by making the marker a different color than the other markers in the graph.
If it is possible, how?
Thanks.

Andy Pope

marker style change for an individual month
 
Hi,

Have a look at Jon's page on conditional charts, looks like a marker
example about 1/2 way down the page.
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

JH wrote:
Is it possible to change the individual marker style for a particular month
in a line graph in the same way we can do conditional formatting for a cell?
For example I want to show that a month in a line gragh met a specific goal
by making the marker a different color than the other markers in the graph.
If it is possible, how?
Thanks.


--

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


All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com