Seeker After
Member
Hello, all! I am a total newbie to forum posting, I usually read them and learn so much. Thanks for the years of Training. I am trying to create a Dynamic Chart with dates and formulas in the data set (see attached file) and it has me totally stumped. The chart needs to include data from the Date/Time (B, the X-axis), DATA1 (C), MEAN (D), Upper (E), and Lower (F) columns.The data in columns H-L is the data from the same columns recombined in a table. The challenge has been to get a dynamic chart that does not interpolate the gaps in-between dates into the chart and will still auto-update.
Up to this point, I can only do one or the other with this data set. The chart based on a table range will not (but should as I understand it) allow the chart to auto-update but does exclude the extra dates on the X-axis. The chart based on named ranges with offset formulas does just the opposite, allowing the auto-updating but will not exclude the unwanted dates. I can't seem to see another option. I have created simpler datasets and achieved success, not with my data.
Thanks in advance.
Up to this point, I can only do one or the other with this data set. The chart based on a table range will not (but should as I understand it) allow the chart to auto-update but does exclude the extra dates on the X-axis. The chart based on named ranges with offset formulas does just the opposite, allowing the auto-updating but will not exclude the unwanted dates. I can't seem to see another option. I have created simpler datasets and achieved success, not with my data.
Thanks in advance.
Attachments
Last edited: