x values =SUMMARY!$A$2:$A$23
y values =SUMMARY!$B$2:$B$23
The only way I know how to change the cell ranges is to modify them directly in the ‘’select data’’ window.
Is there a way to modify them exterior to the ‘’select data’’ window by using cells to control the x and y values? I have unsuccessfully experimented with the address function.
My upload didn't work. I get the message
''FOR EXCEL FORUM.xlsm: Invalid File''
Please advise.
Comment