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?