Lose Percent format when copying a chart and breaking the link

  • Thread starter Thread starter cab58
  • Start date Start date
C

cab58

I have a line chart with the data table showing. The data is in the
percent format. I copy the chart and paste it into a new workbook,
then break the links by doing Edit, Links - then break the links. The
percent format in the data table changes to decimal format.

Is there a way to get the format to stay as a percent? Or to change it
back to a percent?

Thanks for any help!
 
If the chart is just for display and you don't need to edit it in any way a
quick fix would be

select the chart, hold down shift and do edit>copy as picture, select as
screen, then paste it into the new workbook


Another would be to right click the axis in the chart after you have broken
the links and select format axis, then select percentage
 
Back
Top