JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,487
- Office Version
- 365
- Platform
- Windows
Suppose I have 10-12 sets of Y values for a chart in B5:B100, C5:C100, D5:D100, E5:E100, etc. They all have the same X values in A5:A100
Is there a way that I can quickly and easily select one of the sets of Y values and have the chart immediately display the associated graph?
I suppose I can write a macro that will let me enter the column letter (A, B, C, ...) and have it copy that set of data to the range that is assigned to the chart.
Is there an easier way?
Thanks
Is there a way that I can quickly and easily select one of the sets of Y values and have the chart immediately display the associated graph?
I suppose I can write a macro that will let me enter the column letter (A, B, C, ...) and have it copy that set of data to the range that is assigned to the chart.
Is there an easier way?
Thanks