Hey there Im new to the forum and I have abused the search bar with no help...


What Im trying to do is make a chart that can self adjust to a set of cells. For example when I input a diffrent number of rows and columns in the elevation grid dimensions and i proceed to the height input I get the new set of cells but the chart dissapears. I would for the chart to simply adjust to the new dimensions.

I think since when you adjust the elevation grid dimensions and click on the macro for "proceed to height input". It takes you to the height input sheet with the the cells highlighted. Can I make a macro that will make a chart according to the new cells. What if i go back to the elevation grid constraints and change values, would the chart disappear?

Sorry If I'm being too nooby. If you guys want I could delete this and continue searching...

Elevation Grid Generator.xlsm

Help.jpg