My favorite on that front is Jon Peltier’s (if you get intrigued by this post, hop over and peruse a slew of other ways to have charts dynamically update).
This post describes (and includes a downloadable file of the example) a technique that we use extensively to make short work of updating recurring reports. I like to just have the first worksheet as the presentation layer — let’s name it Dashboard — and the second worksheets as the data layer — let’s call that Data.
It’s pretty easy to set up data and create a chart in Excel.
Not only is that time you don’t have, but it could lead to errors, which would be embarrassing.
The easiest way is to use Tables as the chart source data.
A bit more complicated is to use Excel’s Names to define the series data for your chart.
I suggest you consider creating the graph in Power Point with data copied from Excel.
Set up the data required for the graph in a set of Excel cells.