offset scroll bar on graph

[jw01]

Hi
Im having a boat load of trouble trying to figure out how to do a scroll bar on a graph. im not sure if its the holiday hangover or what, but i cant seem to get my head wrapped up around the offset formula to create a scroll bar graph.

can someone pls help me. my graph is stretching really long so it would be great if someone can help me with this, pls and thx you. happy new year.

i have attached a sample.

[teylyn]

Hello,

see attached.

I've inserted a spin button for the number of data points to show on the chart and a slider for the start column of the chart.

The formula for the chart Axis range name is

=OFFSET('Summary Graphs'!$A$5,0,start,1,chtWidth)

and the data series are defined like

=OFFSET(ChtAxis,1,0)

Have a look at the range names and their definitions. I've applied the range names to the upper chart and resized it. Is that what you are after?

cheers