I am having an issue, where I have some statistical data in excel, and transferred data into a graph. I have sinced copied the graph from excel into a word doc so I can place some commentary around the info, and all the colours of the lines have changed, and some of the colours have duplicated or so similar that you cannot really tell the difference of them?
Can you assist me with this please?
Steve.
That sounds very strange.
What version of Excel & Word are you using? It sounds like a bug. If you are able to send through a copy of the Excel file and what it looks like when you paste it into word, I can take a look.
The other option of course is simply to leave the file in Excel, and write commentary around it – but you should be able to simply copy and paste graphs from Excel to Word without the colours changing.
I will take a look.
Submitted by danielle on Mon, 20/07/2009 - 18:00.
Danielle, the chart I’m referring to is on the chart tab in the worksheet, and the copied version is under heading 4 of the work doc.
We use office 2007 here, the strange thing is, that when I paste it to an ordinary blank word doc, the colours remain the same, when I paste it into the report I’m writing using our report templates, the colours change.
Hope you can help me with this
Submitted by Anonymous on Tue, 21/07/2009 - 18:00.
Ah, I see what you mean. It's because you have a Style theme formatting implemented on that document. But if you take it off you lose all the theme formatting on the rest of the document. I'm just trying to work out how to change the chart only. A section break might do it....
No, the only way I can see (if you want to retain the formatting on the rest of document) is to change the colour of each series manually - this is a bit of a pain though if you have to keep updating it. This is probably more of a word issue really than Excel.
I would use Print Screen to get around this.
Submitted by danielle on Wed, 22/07/2009 - 18:00.
Post new comment