Lose Percent format when copying a chart and breaking the link

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!
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Breaking Formulas using Pivot Table 1
Lost Formatting When tab is copied 2
Function to format a value into percent with no decimal 3
Sending Email in Excel 3
Format a Percent 4
Format in Text Field Changes 6
Numberformat applied but does not change data 11
Two folders same name??? 6

Top