If you’re like me, you love the idea of charts and can think of dozens of useful applications for them, but when it comes to creating them, the frustration starts.

Charts often make decision making easy. They’re a nice change from staring at rows and columns of numbers. They add some style and pizazz to your documents or presentations. Creating charts in Excel seems complicated, so you end up settling for simple charts which require a lot of work to maintain.

In my full time job, charts help shorten the decision making process, as we can immediately see our results and where changes need to be made. The difficulty in handling data and charting it is you constantly have to go back to the chart and update it for new data.

Well, no more! I want to show you three easy steps to creating charts in Excel that self-update. All you’ll have to do is add data to the spreadsheet and the chart will automatically graph it. 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