I am using Excel 2007.
I am wanting to plot data for categories in a certain dept such as plumbing.
I have about 10 different categories for which I plot out data for "year to
date" and "week to date".
"week to date" data is in a different section from "year to date" data.
Obviously, the data sorted for "week to date" will be different for the
"year to date" data.
How can you get Excel to retrieve data from cells for a category like
"toilets" so I can plot the data on one graph..
Example: Toilets, "week to date" data, "year to date" data.
I.E., "week to date" data is in J1 to J10 and "year to date" data is in J31
to J40.
"Week to date" data will be sorted in a different order from "year to date"
data.

Thanks