How to fix the chart data

You can unlink a chart from its data ranges and produce a static chart that remains unaffected by later changes in the data.

To convert the chart to a picture, you can use two different ways:

First way: To copy the chart as a picture, do the following:

    1.    Activate your chart.

    2.    On the Home tab, in the Clipboard group, choose Copy and then click Copy As Picture...:

Copy in Excel 2016

    2.    In the Copy Picture dialog box, accept the default settings or change that you want and click Ok:

Copy Picture in Excel 2016

    3.    Click any cell to deselect the chart.

    4.    On the Home tab, in the Clipboard group, choose Paste (or press Ctrl+V) to paste the picture at the cell you selected in Step 5.

Second way: To paste the chart as a picture, do the following:

    1.    Activate your chart.

    2.    On the Home tab, in the Clipboard group, choose Copy (or press Ctrl+C).

    3.    Click any cell to deselect the chart.

    4.    Do one of the following:

  • On the Home tab, in the Clipboard group, choose Paste and then click Paste as a Picture:
    Paste in Excel 2016
  • On the Home tab, in the Clipboard group, choose Paste and then click Paste Special...:
    Paste in Excel 2016

    In the Paste Special dialog box, choose format of your picture:

    Paste Special in Excel 2016