Follow these steps: Now you'll have an opportunity to capture a snapshot of your chart data before the chart is updated.
Help users increase productivity by automatically signing up for Tech Republic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
You could try making a copy of the chart before an update, but Excel is programmed to automatically update any copy of the chart, along with the original.
To keep Excel from automatically updating a copy of a chart with new data, you need to break the link to the source data.
For each of the series boxes, you can click the Collapse Dialog button , at the right end of the Series name or Series values box, and then select the range that you want to use for the table on the worksheet.
In Excel, you can automatically update changed worksheet values in a chart, or you can use ways to dynamically change a chart's underlying data source.You can also manually change a horizontal axis to a date axis.A date axis displays dates in chronological order at set intervals or base units, such as the number of days, months, or years, even if the dates on the Excel sheet are not in sequential order or in the same base units.You can change an existing chart by changing the cell range that the chart is based on or by editing the individual data series that are displayed in the chart.You can also change the axis labels on the horizontal (category) axis.You can also update a chart by adding, changing, or removing data.When you update the underlying data of a chart, the chart's data and appearance also changes.By default, Office uses the smallest difference between any two dates in the data to determine the base units for the date axis.For example, if you have data for stock prices where the smallest difference between dates is seven days, Office sets the base unit to days.To incorporate these changes in the chart, Microsoft Excel provides various ways to update a chart.You can instantly update a chart with changed values, or you can dynamically change the underlying source data.