adjustable data set for graph output

[technoyogi]

Trying to change the source field on a chart by using a acro button

the user can set the amount of data which i plotted on the graph by entering a number into a spreadsheet field

This allows the user to view data in more detail if required using the function to zoo in on a particular section

The first version seems to work setting the nuber to the data set required

Please Login or Register  to view this content.

however when I try to change this to allow the user to vary the data being plotted excel complains of errors

Please Login or Register  to view this content.

Whole code is displayed below

Please Login or Register  to view this content.

[Andy Pope]

Here is an example where there is data in column A:B and number of points to plot is in D1

Please Login or Register  to view this content.

This can also be done without VBA by using dynamic named ranges