Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account



Photo

Excel 2007 chart issues

- - - - -

  • Please log in to reply
1 reply to this topic

#1
careless_hxuk

careless_hxuk

    Newbie

  • Member
  • 32 posts
  • Joined 08-April 05
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.


How to remove advertisement from MSFN

#2
ScottJ

ScottJ
  • Member
  • 2 posts
  • Joined 11-May 11
  • OS:Windows 7 x64
  • Country: Country Flag
You can get some tips on charts from this blog:
http://www.ucmapi.com/chart

Edited by ScottJ, 14 May 2011 - 11:28 AM.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users