Hello,

I am trying to plot multiple lines on the same graph when only one factor is changing, however, the points for each graph are all different.

For example:

Is it possible to plot the function of y = ax^2 + 1, for say 10 different values of ‘a’ on the same chart, without having to type separate calculations for each value. Example of what I don’t want to have to do shown below:

Example of graph I would like to produce without having to copy and paste the calculations multiple times.

For some context, I am trying to see how changing different parameters affect the process one at a time and then see which parameter is most critical. Some of the parameters are simple to change as they do not affect many of the calcs. However, some of them affect about 20 different values before producing the final graph, so I am hoping there is some sort of function such as “plot ‘y’ for each value of ‘a'” to reduce the clutter on my worksheet.

I hope someone understands what I mean.

Thank you in advance.

​Hello, I am trying to plot multiple lines on the same graph when only one factor is changing, however, the points for each graph are all different. For example: Is it possible to plot the function of y = ax^2 + 1, for say 10 different values of ‘a’ on the same chart, without having to type separate calculations for each value. Example of what I don’t want to have to do shown below: Example of graph I would like to produce without having to copy and paste the calculations multiple times. For some context, I am trying to see how changing different parameters affect the process one at a time and then see which parameter is most critical. Some of the parameters are simple to change as they do not affect many of the calcs. However, some of them affect about 20 different values before producing the final graph, so I am hoping there is some sort of function such as “plot ‘y’ for each value of ‘a'” to reduce the clutter on my worksheet. I hope someone understands what I mean. Thank you in advance.    Read More

​