Hi all
I have two columns of identical data except one column is missing numbers.
For example, all the rows in column B contain a number. Column C is a duplicate of column B but some numbers have been excluded on certain rows.
I have already plotted column B on a Scatter X Y graph but I would like the VBA code to search through column C and where there are blank cells, I would like it to shade as light grey. For example, during a 24-hour period, certain data have been excluded in column C, say beween 3:00am and 4:00am. How do I shade the period between 3:00am and 4:00am on the graph (so it looks like a vertical grey bar that extends all the way to the top of the graph) to indicate excluded data?
Alternatively, is there a formula (instead of VBA) I could use to shade the relevant parts of the graph?
Thank you, I look forward to your replies~!
I have two columns of identical data except one column is missing numbers.
For example, all the rows in column B contain a number. Column C is a duplicate of column B but some numbers have been excluded on certain rows.
I have already plotted column B on a Scatter X Y graph but I would like the VBA code to search through column C and where there are blank cells, I would like it to shade as light grey. For example, during a 24-hour period, certain data have been excluded in column C, say beween 3:00am and 4:00am. How do I shade the period between 3:00am and 4:00am on the graph (so it looks like a vertical grey bar that extends all the way to the top of the graph) to indicate excluded data?
Alternatively, is there a formula (instead of VBA) I could use to shade the relevant parts of the graph?
Thank you, I look forward to your replies~!
