Welcome to MSFN

Register now to gain access to all of our features. Once registered and logged in, you will be able to contribute to this site by submitting your own content or replying to existing content. You'll be able to customize your profile, receive reputation points as a reward for submitting content, while also communicating with other members via your own private inbox, plus much more! This message will be removed once you have signed in.


careless_hxuk

Excel 2007 chart issues

2 posts in this topic

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.

0

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.