How to fix the chart data

Excel 365 2016 2013 2010 2007
You can unlink a chart from its data ranges and produce a static chart that remains unaffected by later changes in the data.

You have two ways to do this:

  • Copy the chart as a picture: Activate your chart, hold down the Shift key, and choose Edit -> Copy Picture (This option is available only when you hold down Shift as you select Edit.) The Copy Picture dialog box appears. Click OK to accept the defaults. Then click anywhere in your worksheet and choose Edit -> Paste.
  • Convert the range references to arrays: Select a chart series and then click the Formula bar to activate the Series formula. Press F9 to convert the range references into arrays. Repeat this for each series in the chart. Now the chart can still be formatted. (It doesn't become a picture.)

There is a limit to the length of a Series formula, so the second procedure will not work if the chart series contains many data points.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

Pasting pictures of cells and charts

Pasting pictures of cells and charts

One of Excel's best-kept secrets is its ability to copy and paste pictures of cells. You can copy a cell or range and then paste a picture of the cell or range on any worksheet or chart.
Creating automatically extended plot ranges

Creating automatically extended plot ranges

If you often need to adjust your data ranges so that your charts plot an updated data range, you may be interested in a trick that forces Excel to update the chart's data range whenever you add new data to your worksheet.
Using Arrows in a Chart

Using Arrows in a Chart

Expressiveness of business graphics sometimes determines the success or failure of the presentation and you can achieve better perception of the audience by using in charts intuitively obvious representation of data by arrows.