In this example, we will be creating the Stack Column chart: 2. Open your first Excel worksheet, select the data you want to plot in the chart, go to the Insert tab > Charts group, and choose the chart type you want to make. A great way to create a self-expanding chart in Excel.įinally, give this charting technique a go, it a good one to have in your Excel magic box of tricks. Create a chart based on your first sheet. So, as you can see in the screenshot above Northern has been added in automatically after I typed it then tabbed along to the Widget Sales ready for the figure to be entered. Excel recognises the data as a table and that any data that is added to it, is automatically updated in the chart. Note, if you are using Excel 2003 in Step 3 above choose Data- List-Create List.īelieve it or not, that’s all there is to it!!. Choose Insert- Tables Tables to convert the range to a table In Excel, for example, you can create many different types of charts, including pie charts that present polling results, line charts that plot rising or.Select any cell in the range that contains data that is used by the chart.Create your chart as usual ( you can use the sample data below).To create your self expanding chart in Excel 2007 and Excel 2003 do the following Let’s look at Excel 2007 and Excel 2003 first. So, in Excel 2007 we can use a new table feature if you need the workbook to be backward compatible with previous Excel 2003 versions you need to do a few more clicks to get the same result. We can allow a chart to automatically accommodate new data as it is added.
But, by a few tweaks and Excel magic, we can set up a chart differently. Normally a chart is set up to only display what is currently on the datasheet. So, it is really easy to create a self-expanding chart in Excel.
I will show you how to create a self-expanding chart. Hello Excellers, welcome back to another Excel tip today.