Hi,
I was asked to add a functionality in the VBA tool I'm working on which will format points on chart according to failure code stored in separate column: Run-outs (D) and Fractures (B), values stored in column D, should be indicated on the chart with different markers. The structure of my data is very simple, 4 columns: A-Stress Amplitude, B-Number of cycles, C-Material Name, D-failure code. The chart is scatter type, where values for the X-axis are in column B, and Y-axis values are in column A. Chart series are generated based on column C: each Material Name has separate series.
Can you advise me how to code in VBA different formatting of points based on values from column D-Failure Code?

Thanks in advance
Regards