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
MY videos are all created on Camtasia.