I have a table of data in Excel 2010 that looks something like this (but with hundreds of thousands of rows over multiple days):
I am trying to create a dynamic chart where the x-axis is the timestamp and the y-axis is the value. Each pair of columns is a different series, like so:
Note: The actual chart has a fixed tick width of 1 hour on the x-axis, this is just a quick example I put together.
This is all working fine, but what I want to do is have two cells on the worksheet that define the start and end time of the data to be displayed in the graph.
I want the chart to automatically update (and adjust the x-axis while preserving my fixed tick width) to only include data points between the times I've entered into G2 and H2. Is such a thing possible?