Charting data from a microsoft query

%3CLINGO-SUB%20id%3D%22lingo-sub-3193844%22%20slang%3D%22en-US%22%3ECharting%20data%20from%20a%20microsoft%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3193844%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20sheet%201%20that%20has%20start%20date%20and%20end%20date%20cells%20that%20the%20user%20fills%20out%20and%20a%20microsoft%20query%20bring%20data%20into%20sheet2.%26nbsp%3B%20I%20have%20sheet%203%20that%20has%20a%20line%20chart%20that%20displays%20the%20data.%26nbsp%3B%20My%20problem%20is%20that%20when%20I%20created%20the%20line%20chart%20the%20first%20time%2C%20my%20query%20had%20brought%20in%2052000%20lines%20into%20sheet%202.%26nbsp%3B%20Cells%20A1-U52000.%26nbsp%3B%20On%20sheet3%20I%20created%20my%20chart%20and%20selected%20the%20data%20to%20be%20A1-U52000%20from%20sheet%202.%3C%2FP%3E%3CP%3EEverything%20was%20fine%20and%20I%20saved%20the%20excel%20file.%26nbsp%3B%20The%20next%20time%20I%20opened%20it%2C%20I%20selected%20start%20and%20end%20dates%20that%20only%20returned%201998%20lines%20to%20sheet%202.%26nbsp%3B%20My%20chart%20is%20still%20showing%20data%20from%20A1-U52000.%26nbsp%3B%20The%20majority%20of%20that%20selected%20range%20is%20actually%20blank.%3C%2FP%3E%3CP%3EHow%20can%20I%20tell%20my%20chart%20to%20use%20the%20available%20data%20on%20sheet2%20so%20that%20the%20chart%20displays%20correctly%20no%20matter%20what%20date%20range%20is%20used%20for%20the%20query%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3193844%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

I have sheet 1 that has start date and end date cells that the user fills out and a microsoft query bring data into sheet2.  I have sheet 3 that has a line chart that displays the data.  My problem is that when I created the line chart the first time, my query had brought in 52000 lines into sheet 2.  Cells A1-U52000.  On sheet3 I created my chart and selected the data to be A1-U52000 from sheet 2.

Everything was fine and I saved the excel file.  The next time I opened it, I selected start and end dates that only returned 1998 lines to sheet 2.  My chart is still showing data from A1-U52000.  The majority of that selected range is actually blank.

How can I tell my chart to use the available data on sheet2 so that the chart displays correctly no matter what date range is used for the query?

0 Replies