I am building an excel worksheet and would like to be able to click a button in cell A of each row and have columns C:N appear in a line chart on the screen.
Here is the catch. Is there a macro that I can use that I can assign to multiple buttons that when ran will chart only those columns in its row?
For example, I have data in rows 5:500 and would like to be able to click on any of the buttons in a row and see only thte data from that row in teh chart.
Thanks
Here is the catch. Is there a macro that I can use that I can assign to multiple buttons that when ran will chart only those columns in its row?
For example, I have data in rows 5:500 and would like to be able to click on any of the buttons in a row and see only thte data from that row in teh chart.
Thanks