Damn , I'm getting so confused with this so please help!!

This is what I want to do.

I've got one databasetab with this column :

week1 week2 week3 week4
object1 3 4 5 45
object2 43 34 43 43
object3 88 554
object4

and so on.

Now ik want on another Sheet a box where I can fill in the wee
number and than a chart wil show only the numbers of that week
as:

WEEK #
1000

500

0
-------------------------------------------------------------------------
object1 object2 object3 object4

Hope you understand what I mean and can find a solution for m
problem.

Thanks in Advance !!!

Stif

--
Message posted from http://www.ExcelForum.com

Check the Excel/Tutorials/Dynamic Charts page of my web site,
specifically example 4.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004

In article <(E-Mail Removed)>, Stift
<<(E-Mail Removed)>> says...
> Damn , I'm getting so confused with this so please help!!
>
> This is what I want to do.
>
> I've got one databasetab with this column :
>
> week1 week2 week3 week4
> object1 3 4 5 45
> object2 43 34 43 43
> object3 88 554
> object4
>
> and so on.
>
> Now ik want on another Sheet a box where I can fill in the week
> number and than a chart wil show only the numbers of that week
> as:
>
> WEEK #
> 1000
>
> 500
>
> 0
> -------------------------------------------------------------------------
> object1 object2 object3 object4
>
> Hope you understand what I mean and can find a solution for my
> problem.
>
> Thanks in Advance !!!
>
> Stift
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
>

I will take a look, thanks for the info!

--
Message posted from http://www.ExcelForum.com

Woww cewl It's working, need a few adjustments but that's no proble
!!!

Very great website also !

--
Message posted from http://www.ExcelForum.com

Ok got it working now.
Problem is solved !!

--
Message posted from http://www.ExcelForum.com

Glad we got that going. Thanks for the comments on the website.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <(E-Mail Removed)>, Stift
<<(E-Mail Removed)>> says...
> Woww cewl It's working, need a few adjustments but that's no problem
> !!!
>
> Very great website also !!
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
>