Change Value Series in a Chart from Comand Button

Q

Qaspec

I would like to change the target row of data in the SourceData:Series:Value
of the chart each time I use a command button to select a date from a list.
The data is set up across columns over rows. A3-G3, A4-G4, A5-G5 and son on
depending on date. So if sheet A contains the data and sheet B contains the
chart (chart B), comman button and the list values could this be done
programmatically?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Creating a Chart on form from selected data in query. 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
I want to change the chart series line settings in a macro 2
Setting series values on Excel Chart 1
Setting series values on Excel Chart 0
Multiple chart creation using multiple series in the same row 1
Extend values of a chart series 10

Top