How to create a self expanding chart ? 

Level:Beginner

Thinking of automatic chart update?.. Here is the way folks..

When u add new data to a worksheet , how can me make the chart self expandable?

Solution:

• Select the data u want to make a chart
• Choose Insert->Tables-> Tables to convert the range to a table

Making Chart:

• Now select data table
• Choose insert-> chart -> type of chart

Note:  Excel recogonizes the data as a table, and data added to the table is shown in chart

Chart will adjust automatically according to the data.

Thanks,

Raegle