I have used vba code to interpret an extensive amount of data and am now to the stages of making user friendly graphs. Ideally I would like to have two buttons; one the user clicks to update the graph series by going down a row (“forward”) and one to go up (“back”). The data will always be in a sheet titled “Graph” and the starting row of data (y-axis) is from B32 to CH32. The x-axis values are always in B32 to CH31 and each series title is in the A column corresponding to the row the series data is coming from.

Ideal situation would have a button to update the series up and one down the rows, updating the title of the graph to match the row the series data is coming from. I list box or combo box that is updated with the values in column A from row 32 down to the last row so the user can click on the value they want to reference and it will update the graph to the corresponding row of data.

Im not sure what the best method would be to go about completing this. If it should all be coded in VBA or if the sheet/graph could be set up so that the listbox/combobox updates to include the data to the last row as the data is added to the sheet.

I have attached an example of what the sheet will look like.
ExampleGraphSheet.xlsx