I am trying to create a chart to show weekly data but my spreadsheet is set up to show one row (with a total for the week) and then additional rows underneath displaying the daily info. I'm trying to set up a regular line chart that will display only the "weekly" data.
I can choose my range for the source data by holding the "Ctrl" key and choosing only the rows I want to chart. However, after I've entered maybe 5 or 6 separate ranges, Excel does not let me continue choosing more. I've done this in the past and have had no problems. Any ideas?
