careless_hxuk Posted October 19, 2010 Share Posted October 19, 2010 I've been using Excel 2010 at home to copy and paste some charts from Excel to Word. Now I'm at work, using Excel 2007, and it is giving me all kinds of grief.I have a load of data in a pivot table with a pivot chart linked to it. What I have been doing is changing the filters on the chart, copying the resulting chart and pasting it into Word. Each chart is pasted as a Graphic Object so that I can adjust the formatting from within Word. This is the right thing to happen. However, when I try the same thing in Office 2007, the charts in the Word document change every time I change the filtering on the Excel chart, so I end up with the same chart on every page, which is rubbish. Strangely, it remembers the formatting and title but changes the data and the legend titles.How do I make this work properly in Excel 2007? I've tried pasting as a picture, but that leaves me with no way to reformat the chart once it's in Word. I don't really want to have to do this work at home, but I might have to if 2007 continues to be a b***h. Link to comment Share on other sites More sharing options...
ScottJ Posted May 11, 2011 Share Posted May 11, 2011 (edited) You can get some tips on charts from this blog:http://www.ucmapi.com/chart Edited May 14, 2011 by ScottJ Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now