Dynamic Chart scroll bar

[Plumbstar Tom]

Hi

I have looked all over the internet at dynamic charts and scroll bars and every thing is shownwhen the data is in columns, but mine is rows

I cant get my scroll bar to 'scroll' the chart I have

I think the issue is with my defined names

They look like this

='Sheet1'!$E$3:$AZ$3

which works for a dynamic chart but not whnen I want to add a scroll bar

Can any one help?

 

[p45cal]

Could you post your file (ora simple version of it) on the interweb somewhere - eg. box.net

 

[Plumbstar Tom]

Hi

I hope this will take you to it

http://www.box.net/files#/files/0/f/0/1/f_920105970

 

[Plumbstar Tom]

I am in excel 2003 if that helps?

 

[p45cal]

Hi

I hope this will take you to it

http://www.box.net/files#/files/0/f/0/1/f_920105970

It doesn't, the link should look more like:
https://www.box.net/shared/0x729y5zpl1m3131988z
(not a real link that)

in box.net, click on Share and either it will give you a link or some more options.

 

[Plumbstar Tom]

Here you go p45cal

http://www.box.net/shared/2y2pyezgb9qsg0f4vni3

 

[p45cal]

OK, I can see it now (could have had a little more dummy data in). Is the total sales row in row 4 usually formulae?

Now, how do you want it to scroll?

 

[Plumbstar Tom]

hi

I have no data to put in it yet you see

Row 4 will not be formulae, it will be manually input figures

 

[p45cal]

again: "Now, how do you want it to scroll? "

 

[Plumbstar Tom]

sorry

Scroll to work to show a 12 month period defined by the scroll bar

Is that the information you require?