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
Bookmarks