Then pick a "master sheet" to provide the "cells" that the series will
point to, and in those cells, reference the scattered data.

Rick wrote:

I want the data to be all in the same series.....

"Bob I" wrote:


make the chart with one, then simply add series to put in data from
other sheets

Rick wrote:


I trying to make a chart with data that that s on multiple sheets How do I
select the data? I searched for an answer for this for 2 hours now....