Creating a dynamic chart for data with expanding rows and columns

[katechad]

I want to create a chart that is automatically updated, both when a new row or column is added to the spreadsheet.

I created a name for my dynamic range, using =OFFSET(Top!$B$4, 1, 0, COUNTA(B:B)-2, COUNTA(5:5)-1)]

	a	b	c	d	e	g
1
2
3
4		Top Customers
5		12	Jan 12	Feb 12	March 12
6		Andy	45	54	45
7		Beth	35	45	52
8		Sheba	54	54	42
9		Cassandra	82	50	30
10		Sadra	42	22	55
11
12

<tbody>
</tbody>

I can then create a chart, using this named range as the chart data range. It worked.
However, when I add a column or a row to my data, the chart does not update as I hoped.

Most of the solutions I've looked at for dynamic charts require a name to be defined for each column in the range. This won't work for me, as I need to be able to add columns (and rows) without creating new defined names.

Can anyone help me find a solution to create a dynamic chart for data that will be adjusted both horizontally and vertically?

I am using Microsoft Excel 2010 on Windows.

 

[Derek Brown]

Removed this duplicated post - always seem to have this problem when using Google Chrome on this Board.

 

[Derek Brown]

Hello and welcome to The Board.
You will find the answer to this and many more answers and ideas about charts at Jon's excellent site:
Jon's Excel Charts and Tutorials - Index
Look for 'Dynamic Charts' in the index. You will also find that some articles have a link to download sample files.