self adjusting chart?

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

how about a named range? looks like you've got code in there to create the chart, replace your range with a named range for which the formula is:

Formula:

Please Login or Register  to view this content.

Originally Posted by simarui

how about a named range? looks like you've got code in there to create the chart, replace your range with a named range for which the formula is:

Formula:

Please Login or Register  to view this content.

Okay and will this make the chart adjust to the input values?

Either way I'll go try this out

Sent from my HTC One using Tapatalk

i'm not certain I understand the question... but i think the answer is yes, when you run that code if you reference your named range with the offset formula there the range will grow if you add columns to row 6 or rows to column B.

Originally Posted by simarui

i'm not certain I understand the question... but i think the answer is yes, when you run that code if you reference your named range with the offset formula there the range will grow if you add columns to row 6 or rows to column B.

hmmm Where do i put this code? Withthin the macro?

Please excuse my stupididty....

the formula that I wrote is intended to be a named range (Formulas/Define name) where you can pick whatever name you want and in the "Refers to" box you put my formula.

Then in the create chart macro there's a line of code that defines your range, you should just need to replace the defined range with whatever you named your named range.

Untitled.jpg

Sorry but i didnt make the macros

But im guessing I just copy and paste it there?

leave =Range("") ... so it should be something like =Range("whateveryounamedyourrange")

Originally Posted by simarui

leave =Range("") ... so it should be something like =Range("whateveryounamedyourrange")

Ahhh ok thanks I'm gonna go try it now!

Sent from my HTC One using Tapatalk