Control Charts-Line plot points same color as cells

Hello ExcelForum,

I am extremely new to coding in VBA and have been put on an assignment where they want me to create self generating control charts that require little physical maintenance.

I have most of it figured out, but the major issue I have is that I can't find any resources on how to make the points on a plot the same color as the cell the data is drawn from.


To put it as simply as possible, I was wondering if there was a way to have a plot point become red if the cell the data point is from was colored red itself.


Thanks for your time/any help which can be provided.