How to fix the chart data

Excel 2016 2013 2010 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 copy the chart as a picture, do the following:

   1.   Activate your chart.

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

Clipboard in Excel 2007

   3.   On the Home tab, in the Clipboard group, choose As picture list, and click Paste as Picture:

Paste in Excel 2007

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