Can Excel do this?

[Charles Eaves]

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

 

[Shane Devenshire]

Hi,

You can do this with a data validation drop down and some VLOOKUP formulas.
But to say more we are going to have to see a sample of the data and what you
want to plot.

 

[Charles Eaves]

Thanks Shane.
I will give it a try and see from there.
Thanks Again.