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.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 keep Excel from automatically updating a copy of a chart with new data, you need to break the link to the source data.
If you create a chart based on a cell range, updates to data within the original range are reflected in the chart.
But to expand the size of the range, by adding rows and columns, and change the chart's data and appearance, you must manually change the original data source in the chart by changing the cell range that a chart is based on.
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.