Hello,
I need to simply drop large sets of data on a sheet, and then chart it out by month. I avoid using filters because it needs to be pasted (interval data - and a lot of it)
I have been using scatter charts, and usually I am able to see the "source data data range" outlined in a thin blue line when I click on the entire chart. Typically, I make a copy of the chart, click on the new chart which then shows the data range outlined in blue, and simply relocate the blue lines (the series are shown in red ) over the new set of data. (I'm looking at interval data from several months and years)
This is a real time save for analysis of large sets of data I look at.
In my new charts, I have been forect to break out the data to other worksheets using "if" formulas (I am trying to avoid using filtering if I can because it isn't effective when it comes time to pasting large sets of data, and thea amount of time spend re-graphing is great).
In these new charts, the blue outline for adjusting the data set is no longer visible. When I select the data range Data Source Data range, the data is outline in dashed lines.
Any help would be greatly appreciated