Dynamic Chart

[Steviebhoy]

Have a chart with 4 series in it, simple enough.... want to have it show the year figures, inputs are weekly, as they are. eg from week 1 to present week 33.
have tried to set up dynamic chart, so when next weeks figures are put in it updated this automatically

Have tried offset command along with counta but getting invalid enrty
using colum b,c,f & g, so when week 34 is inputed graph will up date to include that week

-- removed inline image ---


Using excel 2002

Thanks

 

[Jon Peltier]

Your pictures didn't come through, your description says only what you tried in the vaguest terms without any specifics, and there are no details about what went wrong.

 

[Steviebhoy]

Hopefully it will take the pics


-- removed inline image ---


Data from colulms B,C, F & G

looking for a dynamic chart that will update with this weeks figures weeks 1-33 this week, 1-34 next week, when figures go in

hope this explains it

thanks in advance

 

[Steviebhoy]

hopefully this will work

data in columns b,c,f & g

Thanks In Advance


-- removed inline image ---

 

[Steviebhoy]

At work, so limitations at work thin client stopping jpg being added, will do at home tonight, thanks for your patience

 

[Jon Peltier]

Are you looking for a dynamic chart?

I've written a tutorial showing how to make Easy Dynamic Charts Using Lists or Tables.

 

[Steviebhoy]

was able to set up table from data at home with 2007, but can't seem to do this with 2002

Anyone any ideas, pics won't load

 

[Jon Peltier]

You're definitely not conveying your thoughts effectively. Most of the time, pictures are not needed to describe an issue, so forget about them.

Think of what you want to say, and think of what information will make it easy for us to understand the issue so we can actually help. For example, what is the formula you tried for your dynamic range? If you just say "using colum b,c,f & g", nobody knows what you're talking about.