Interactive data entry and updating
The end goal here is to create a table that feeds data to a chart.Linking these two elements together allows the chart to check for newly added data in the table.
For my example project, I’m creating a chart that tracks sales of each Harry Potter novel at a bookshop.In the Create Table dialog, you can tweak the cells included in the table.Tick the box labeled My table has headers, then press OK.Date formatting can be a little tricky, so I’ll drag the bottom right corner of the cell down to populate the cell automatically.Of course, I could do this manually — I’d just have to lay out my date in the same format as preceding rows.To add more data, simply add another line at the bottom of your existing chart.
Since my Date column dictates the values on the X-axis of my chart, I’ll start there.
You won’t have to depend on others to manipulate or mess up the chart, and you won’t have to do all that extra work either.
You don’t need any Visual Basic skills, but you do need to understand the basic fundamentals of Excel charts.
You can now use the chart indefinitely, simply by adding more rows to the table.
However, you may have to tweak its size and formatting to present all the data properly, depending on how much you’re planning to add.
One of the most powerful aspects of Excel is the fact that various aspects of spreadsheets can be automated.