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

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Charles Eaves" wrote:

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

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

"Shane Devenshire" wrote in message
...
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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Charles Eaves" wrote:

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