I have a candle stick charge with Date/Open/High/Low/Close Columns. I have a drop down menu to select time I want to see, example 1 month 6 months ect. Currently I have about 2 years worth of data, if I want 1 month I have an if statement that if outside the dates the cell is blank "".
The main issue is the dates, I do not want weekends included just the data in the table. I can convert date to text but when I do this and I look at 1 month worth of data I end up with 24months - 1 month of blank data in the chart. I want it so that if I chose 1 week, 1 month or 1 year I only get those data points and exclude any blanks.
data table is (E81:I585) E=header
Can anyone point me in the right direction as to how to address this?
Thank you
MM
The main issue is the dates, I do not want weekends included just the data in the table. I can convert date to text but when I do this and I look at 1 month worth of data I end up with 24months - 1 month of blank data in the chart. I want it so that if I chose 1 week, 1 month or 1 year I only get those data points and exclude any blanks.
data table is (E81:I585) E=header
Can anyone point me in the right direction as to how to address this?
Thank you
MM