Chart ''select data'' specification''

[joemiller]

The ‘’select data’’ window for the chart in the attachment displays
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.

[NinjaTrader_CalH]

Hello Joemiller,

I need more information here as to what you are doing. None of these variables or items you are describing are within NinjaTrader.

What exactly are you trying to accomplish?

[joemiller]

My mistake!
Meant to send this to an excel forum.