Insert Graphs [that automatically update based on variables]

Hello, quibilty. I hope it is not too late for this.

I did it with helper columns, the first starting in A26, with this formula, copied down to A100:

Formula:

Please Login or Register  to view this content.

Next in B26, with this formula, copied down to B100:

Formula:

Please Login or Register  to view this content.

Then I use the Name Manager in the Excel Formula ribbon to create dynamic named ranges to select data for the graph.
For example, for the X-axis I created the range named Index, with this formula:

Formula:

Please Login or Register  to view this content.

To view those named ranges, right-click on the graph, then click Select data.

Please run some test and let us know how it goes.

Good luck!

Thanks a lot for this, this is really great. I do have some feedback/questions:

1) For tab 1a's graph, is there a way to make it so that the "MIN" and "MAX" level (the black lines) appear at (lowest value - 1) and (highest value + 1)?
2) I don't see a graph for 2a. Did you include a graph on tab 2a that reflects the data in tab 2, or am I just missing it?

Thank you so much for your help.

Hi. You're welcome.

I have added columns for max and min values, so as to add them to your graph.
But I made them (lowest value - 0.5) and highest value + 0.5, so the lines show closer to actual values in the graph.
Also, I have added a graph to the other tab, no helper columns required.

Estevaoba, thank you again. We're soooo close! A couple things.

1) Would you please re-create those charts in tab "Sheet 2" in the attached file?
2) Would you please set the min and max levels (the black lines) for the graph with 64 plot points to the values that are at F38 and M38?

This way I should be able to copy/paste the graphs onto the original document and use the search/replace feature to make the formula work on the original document.

Thank you.

I took the text values from the range rows and used extraction formulas to create min/max rows for the first graph.
Please check attachment.

I'm not sure what happened, but the chart on the left has changed so that it's now incorrect. The min and max values of points 2, 3, 14, and 15 are zero when they should be (point 2; 23.3 min, 28.3 max), (point 3; 21.5 min and 26.5), (point 14; 21.5 min and 26.5), and (point 15; 23.3 min, 28.3 max). Are you able to change that?

Also, do you think you can add a line that shows the "average" value in the form of a red line on the graph?

Thanks a lot! This will be so helpful once it's done.

I had the same error in those four points, because the decimal separator in my Excel language (Portuguese) is a comma. But I thought there would be no error for you, since a period is used as decimal separator in English.

=VALUE(LEFT(C13,SEARCH(" -",C13)-1))
The formula above, for the minimum values, should result 23.3 for you in C15, but for some reason it results an error.
So I added the SUBSTITUTE function, just like I did it here, as in the formula below.

=VALUE(SUBSTITUTE(LEFT(C13,SEARCH(" -",C13)-1),".",","))

Also, I have added a new helper column for the average line in the second graph.

Sorry for the late reply. I've been taking some training the last couple days. Tomorrw I'll go to sea and Internet service onboard is not very good, so I may not be able to check this thread in the next four weeks, but I'll try.
I hope this will help you with your project.

Have a blessed day.