In Excel 2007, 2010 or 2013, you can create a table to expand the data range, and the chart will update automatically. Select the data range and click Table under Insert tab, see screenshot: 2.
In the Create Table dialog box, if your data has headers, please check My table has headers option, then click OK. And the data range is formatted as a table, see screenshot: 4.
3D Chart: Add depth to a basic pie chart with the 3D option.
Now, when you add values for June, and the chart will be updated automatically. Your new entering data must be adjacent to the above data, it means there is no blank rows or columns between the new data and the existing data. In the table, you are able to insert data between the existing values.
But sometimes, you don’t want to change the range to table, and the above method is not available in Excel 2003 or earlier version.
It’s full function without limitation in 60 days,please download and have a free trial now.
If there are multiple type of graphics in a workbook, and you just want to export all charts across worksheet to a folder as gif of other type of picture, you can use Kutools for Excel's Export Graphics utilty, which only need 3 steps to handle this job .
HI, This trick doesnt work if you want to add new columns. What if there is a data yearwise in columns and every year a new year column is added so how will it get added to the chart ??