I have the following situation:
- I have a cell A1 that contains a function where the value changes based on the values of cell B1, C1, D1.
- I would like to make a line graph where Y-axis is all possible values (0 to 9999) of A1, X-axis is all possible values (0 to 9999) of B1, and I can play with values C1 and D1 to change chart instantly
Is such a thing possible? Usually I use two sets of series but this is different.
Thanks!
Bookmarks