i have created a chart where X axis holds values in column A (showing dates) and Y axis holds values in column B (showing prices). the chart has been plotting on a separate sheet.

I am trying to write a excel vba code where for specific values of Y based on if/than statement in column C, the corresponding datapoint in the chart is resized/colored (essentially highlighted on chart).

I am struggling here a bit.

I appreciate your input.

thanks.

nqh