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.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more