Anchor chart source data?
 

Hi,

I have a worksheet where I add new data by inserting rows at the top o
the sheet. This works well for formatting (so I see most recent value
at the top) but unfortunately breaks my charts on the sheet. This i
because when I insert a row, the charts source data goes from this:

='Investment M&G'!$A$2:$B$745
To this
='Investment M&G'!$A$2:$B$2,'Investment M&G'!$A$4:$B$746

Does anyone know how I can always anchor the chart to the first sourc
data statement such that I don’t always lose the top line of my data o
the chart when I insert a row

--
dazma
-----------------------------------------------------------------------
dazman's Profile: http://www.excelforum.com/member.php...fo&userid=2590
View this thread: http://www.excelforum.com/showthread.php?threadid=39390