How to fix the chart data

Excel 2016 2010 2007 2003
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 2013

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

Copy Picture in Excel 2013

   4.   Click any cell to deselect the chart.

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

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 2013
  • On the Home tab, in the Clipboard group, choose Paste and then click Paste Special...:
    Paste in Excel 2013

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

    Paste Special in Excel 2013

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