• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unlink graphs from Data in Excel

J

JuliusV

Member
I had a bunch of graphs from one workbook and pasted it to a new workbook. When I try to open this new workbook with all the graphs on one tab, it tells me that this workbook contains links to other data sources and even if I ignore the links, all the graphs will get messed up.

Is there a way that I can keep all the compiled graphs I have on the new workbook and keep it the way it currently is? I am trying to avoid going back and changing each one to a picture and re-pasting it.

Thanks for the help.
 
Hui - Thank you for your response.

I did break the link but it messed up all the graphs I had on my new workbook. For the future, is there another way that can preserve the graphs that I have on the workbook?

Additionally, I wanted to avoid making it a picture, so that I could still edit the graph.
 
Select the chart and the series
Click in the formula bar
Press F9
Then press Enter

Repeat for each series
 
I tried pressing F9 for the series of data, but for my x-axis I had dates and instead it transformed all the dates to other numbers, which I assume represent the source code for excel.

How can I go about avoiding that scenario?
 
Actually I have one last follow up, when I do change it back to the date axis after doing F9 and editing the Numbers Tab back to dates, the Axis Options tab does not give me the ability to change the x-axis so that it can be adjusted into months. Right now, the x-axis scales adjusted itself automatically.

How can I go about so that I still have the option to adjust the x-axis with months?
 
Last edited:
You must log in or register to reply here.
Back
Top