Format points on chart according to cell value

[crimsontrooper]

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

[MrShorty]

Jon Peltier has a routine on his site that will color points by value using VBA: https://peltiertech.com/vba-conditio...arts-by-value/ Will something like that work for you?

[crimsontrooper]

Hi, thanks.
I've done it this way:

Please Login or Register  to view this content.

However the problem is, it does not format all points, only odd entries (e.g 1, 3, 5) in every series. Any idea how to fix this? The FArr array stores string values from column D.

[crimsontrooper]

Ok, I've got it to work.
The line: J = j + 1 was forcing the code to skip the even numbers. After removing this line everything is working correctly.