Well, what do you do if you want to edit the chart data after a week, a month, or even a year after you created that chart?
Simple -- you just summon the instance of the Excel sheet containing the chart data again and make the required changes. Or do you want to know if your favorite keyboard shortcuts are documented?
Instead, insert some blank rows somewhere within the data range; it doesn't matter where, as long as the record for 11/13 is below the added rows.
In this article Add a Standard Module to a Power Point Presentation Add the Code to the Visual Basic Editor Test the Solution Next Steps Published: March 2011 Provided by: Frank Rice, Microsoft Corporation Microsoft Office 2010 includes a powerful and versatile charting engine.
You can chose from many common business and technical chart types.
The first shortcut works fine if you simply need to "fine tune" the range used in a chart.
(This approach only works if the chart is on object on the same worksheet that contains the data on which the chart is based.) Follow these steps: That's it—Excel incorporates the new data right into the existing chart, slick as a whistle.