Graph with scroll bar

[pauldaddyadams]

Hi ,

I wondering if anyone can help.

I have a graph I need to create with the added functionality of a scroll bar which dependant on its position would show 6 months worth of data. The user would then be able to scroll through the months and the graph would update automatically.

I have provided an example of a static graph showing the data I need as reference. This Graph is on the “dashboard” sheet Rows 40-65

Has anyone got an example of a graph like this I could look to replicate or a tutorial?

[pauldaddyadams]

I found this..

I may post back on here if I get stuck

[pauldaddyadams]

Offset Function

Can anyone tell me what the following would be for my data:
SCROLL_LABELS
SCROLL_DATA

I am trying to replicate the graph I have which is plotting:=CALCS!$B$81:$AL$81,CALCS!$B$84:$AL$84

Can anyone help - I have attached an example and the template I am trying to replicate ("Template")

[pauldaddyadams]

Hi, Can anyone help with this?

I tried
Scroll_Lables:

Please Login or Register  to view this content.

Scroll_Data:

Please Login or Register  to view this content.

But this didnt seem to what - Arrraaggghhh!!

[pauldaddyadams]

Shameful Bump

[Andy Pope]

SCROLL_LABELS: =OFFSET(CALCS!$B$81,0,Dashboard!$I$40,1,Dashboard!$I$41)
SCROLL_DATA: =OFFSET(SCROLL_LABELS,3,0)

Series formula

=SERIES(CALCS!$B$84,Upload.xlsm!SCROLL_LABELS,Upload.xlsm!SCROLL_DATA,1)

[pauldaddyadams]

Thanks Andy!! You always help with any Graph problem I have!!