I have a chart of my table, but I keep adding rows to it.

Is there a way to define the chart's Series/X-Axis/Range as part of a formula?

I want the graph to grow as my table grows - dynamically.

1 Answer 1


Maybe it depends upon the chart type chosen (which you have not mentioned) but incorporating blank rows into the initial selection allows for future expansion. In effect, instead of growing as more data is added, the graph shrinks down to a size to match the data - so as more data is added it just shrinks less.

Basic chart

Add date

Add value

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.