Forum Discussion
Graphing based on a Changing Array
I have an excel spreadsheet with two columns, 50 rows each. I would like to graph these columns, one on the x-axis (Quantity) and one on the y-axis (Unit Price). The data in the two columns, changes ...
You can define dynamic named ranges for the x-values and y-values.
See the attached sample workbook.
To see the definition of the ranges, click Formulas > Name Manager.