Formatting Graphs and charts with data in cells

[cody.starr]

I am putting together a workbook that is used for measurement evaluation. I have created a tab where if i input the dimension number it fills in the data on the page using vlookup.

The problem i am having is with the graphing, I am using an XY scatter graph to display data on a vertical line. what i would like is for the vertical and horizontal axes to update based on the dimension number and size. I would think this is a macro situation but would like to avoid that if possible.

currently i would have to change the graph every time i change the dimension this is too time consuming.

Groom workbook.xlsx

[Kaper]

How about some normalization of your data?

As your charts are "graphics only" with no numbers in any form displayed, you could write in

G25: 1
G26: =(G21-G22)/(G20-G22)
G27: 0
G28: =(G23-G22)/(G20-G22)
G29: =(G24-G22)/(G20-G22)
G30: =(G18-G22)/(G20-G22)

and of course, use these values for series (instead of G20, G21 ... G24 and G18)

now you can have axsis from 0 to 1 (or may be from -0.05 to 1.05 which I used in attachment or similar -0.03/1.03 ? to have some margin below smallest and above highest) and as you change input data, the results will remain on scaled axis