Dynamic Horizontal + Vertical chart

Hi,

I need a chart to can be expanded vertically (limited to say 10 rows) and horizontally (no real limit).

Now I don't have a lot of experience with excel. From what I have seen so far is that you give it the range to use (but this gets replaced with a absolute value) then you edit the seriesNames and add a OFFSET formula for the values. The Label range is also a OFFSET formula.

The only way I have found to make the graph expand vertically as well is to add the empty rows below the current ones to the graph as series and a OFFSET for the empty values so when this is populated its added to the graph. EDIT: ok it seems like you can't use a OFFSET formula that has all its fields empty as a values field for a graph.

I would just like to know if there is another/better way to do this.
I have attached a sample excel file (it does not have the empty rows added as series values etc)

testingGraph.xlsx

hi
check this link, it might help with dynamic ranges with charts

http://chandoo.org/wp/2009/10/15/dyn...t-data-series/

Hi,

Yes I used that to get a start, but all these examples are only for a chart that expands either horizontally or vertically. Mine needs to expand BOTH ways. And as far as I can tell you need to add each series ( the vertical growth ) and set its values to a offset formula.

Did you look at the file I attached?


EDIT: The link basically tells you that you need to add every series value separately with its own offset formula then it expands either horizontally or vertically (since the value can't be more than one row/column)