Create a Dynamic Chart in Excel

Quite often you require a chart to which you can constantly add data.

The method to achieve this is by using a table for you data.

If you have your data already entered

Click within the data and select the insert tab

Click insert table

The system will show you which data that it will make a chart from, if this is correct click ok.

Select your data and insert any chart type that you desire.

Create you chart,

Enter additional data to the table and the data will be reflected in your chart automatically

How to create a Dynamic Chart in Excel