Does anyone have any VBA that will alter my charts marker line color if the axis label matches a certain value?
For example; My y axis will have consistently named axis labels, such as analyte 1, analyte 2, analyte 3, 4, 5 etc., but sometimes I will not need to chart analytes 3 and 4. This means analyte 5 assumes the third position in the chart which then takes on the color of the previously charted analyte 3.
I would like to run some vba to change the chart marker line colors to match the analyte name and not be associated with the chart position.
In other words analyte 5 should always be RED no matter where it falls on the chart.
Any ideas? Thanks
For example; My y axis will have consistently named axis labels, such as analyte 1, analyte 2, analyte 3, 4, 5 etc., but sometimes I will not need to chart analytes 3 and 4. This means analyte 5 assumes the third position in the chart which then takes on the color of the previously charted analyte 3.
I would like to run some vba to change the chart marker line colors to match the analyte name and not be associated with the chart position.
In other words analyte 5 should always be RED no matter where it falls on the chart.
Any ideas? Thanks