Offset()

[Kavy]

I have the following offset function for my graph source data:

OFFSET('Piping Graph Data'!AK3,0,0,AK1,5)

where in cell AK1 is a count function to tell the graph how many rows to actually graph.

This works, but when I go back into the source data for the graph, it has removed my formula and shows the actual ranges it plotted. This makes it so the count function won't auto-update the graph range, since excel has removed it from the formula itself!

Any ideas??

Thank you!

Kavy

 

[Kavy]

So to update this, I realize I needed to create a dynamic name range with my formula and than enter it into the graph.

I have tried this but my excel likes to edit my range, and I can't get my chat to accept the named range.

I have seen online examples where people generally include the name of the worksheet in there named range, but that doesn't seem to help either.

Does anyone have any idea?

 

[Kavy]

So i got it,

Ensure your name has the worksheet name in front of it, ending with a "!" before the name,

i.e. Sheet1!NAME

Ensure your offset formula in your name includes the worksheet names for all cell references, not just the cell

Input your new dynamic names into the graph by clicking the graph and using the series function in the formula bar (which should auto appear). Ensure you have a x-value ma,ed range as well as a y named range both having the same length in your series function.

Google the series function in graphs to see the requirements.