Hi all, I have created a line chart using stock data from existing data within a worksheet. What I would like to do is add data to the worksheet and have the chart automatically include this data within the chart. Currently, I have to manually go into the chart and change the data range. As I have many charts to change this can take a lot of time. If I add blank cells to the data range within the chart then the chart includes this range makiing it a small chart with lots of space on the right side. I'm using Office 2007 and thanks for any suggestions!