Adding new data to existing graph

Hi Amy

Thanks for getting in touch. The best way to do this is convert the source data into a table.

To do this, click inside your data (the dates and amounts etc). On the Home tab, click Format as Table. You then have to choose a style, but you can remove this afterwards if you like. Click OK to confirm that it has captured all the data.

Now go back and highlight the entire table. Create the chart as normal but note that when you add a new row to the table the chart will automatically update.

I hope this helps.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector