Excel 2007 line-chart pasted as an enhanced metafile - editing



  • 1. Excel Charts when I mouse over a certain cell...
    i have an excel chart, a scatter diagram, which is working perfectly fine as it is. I just want to know if there is any way in which I can put this chart in a comment or click a button which will display the chart and ensure that the chart gets updated as the input values change??? Is this possible??? I tried the solution which Ed had suggested but the thing is I have 15 charts to display and hide on the mouse over event and am now struggling again with the same..Any cell I click gives me an error message.. I believe that it would chart the chart on its own based on the range selected, hide it, and then display it on recognizing the cell selected depending on the color and the font of the cell. Any advice would be really appreciated.. Thanks, Ace
  • 2. Chart Font Color Disappears when copying to Powerpoint
    Hi, I have a Chart Sheet which I want to copy to Powerpoint. I used to just be able to copy and paste to powerpoint and it would work perfect. Now for some reason, I loose all font colors. Not sure what has happened but if someone has an idea please let me know. I was able to get it to work properly on a Non-Chart type of sheet using Shift-Menubar-Edit-Copy Picture but that option isn't available on a chart-sheet. It's also important to note that the chart-sheet has macro buttons that I don't want copied to powerpoint. They are formatted as "Non-Printable"... Thanks for any ideas, MikeZz
  • 3. Remove null value categories from graph
    Hi, I am preparing a dashborad on a daily basis by putting the sales data. X axis will be the date and Y axis will have the sales value for the particular date. some of the dates there won't be any sales,ie. zero value.while drawing graph i will select the entire range, so all the dates will be appearing on X axis even if the value null. could anyone help me on this to remove the zero value dates from the X-axis ?

Excel 2007 line-chart pasted as an enhanced metafile - editing

Postby QmVuIEVkd2FyZHM » Sat, 06 Oct 2007 19:14:00 GMT

To tailor all our charts we past/special/metafile line charts into 
Powerpoint, then ungroup twice to be able to move/chop/change elements of the 
chart. When I ungroup the second time the line (representing data) actually 
breaks into a huge number of invidual lines (according to the underlying 
source data), as opposed to one single line. As a result, things are much 
more tedious/complicated. Any way to ungroup a chart in Powerpoint and have 
the line stay as a line, and not a ton of individual lines?

Re: Excel 2007 line-chart pasted as an enhanced metafile - editing

Postby Jon Peltier » Sun, 07 Oct 2007 04:15:16 GMT

I'm actually disgusted with how 2007 ungroups a chart into shapes. You don't 
get individual gridlines, for example, you get an indivisible set of 
parallel lines. And line chart series give you a polygon rather than a set 
of line segments. Both of these shapes are called freeforms, but you are not 
able to edit their nodes to change the shape. Also, what should be lines are 
not lines: the axis is converted to a thin rectangle, and if you're not 
careful, you'll turn it into a thick rectangle.

I thought maybe your series had a dashed line, resulting in the huge number 
of individual lines, but when I tried that, the dashed line still turned 
into a single freeform.

I guess I can't be of much assistance, but if you want to cry into a beer, 
let me know.

- Jon
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -  http://www.**--****.com/ 

Re: Excel 2007 line-chart pasted as an enhanced metafile - editing

Postby QmVuIEVkd2FyZHM » Sun, 07 Oct 2007 13:59:01 GMT

Thanks Jon for your response, and the new changes in the way 2007 charts are 
indeed a big step backwards for the way we do things. There is just know 
where near the ease and edit-ability of ungrouping charts (typically pasted 
as wmf or emf files into Powerpoint), and I reckon we have to go back to 
using Sigma Plot or some such application to get what we need. As a Microsoft 
person, do you think that the changes are fundamental to how things work, or 
could Microsoft come up with a patch or something that made things work 
(lines, not free forms, etc.) like they did before??



Re: Excel 2007 line-chart pasted as an enhanced metafile - editing

Postby Jon Peltier » Sun, 07 Oct 2007 23:03:32 GMT

don't know if there is a sea change in how charts and shapes are going to
behave. I do know that a huge amount of resources were devoted to the new
shapes in Office, and for turning the plain old chart elements into new
Office shapes. I also wonder whether they simply ran out of time and took
the most expedient option. This is backed up by the fact that nothing
related to the new shapes or the formatting of chart elements as new shapes
is recorded by the macro recorder.

I would expect no changes to Office 2007 via patches or other means, except
perhaps to change actual "bugs" instead of ineffectual features. Microsoft
has received a steamship full of comments about their charts and shapes, and
I would hope that these will encourage them to improve the way shapes and
charts work in Office 2010 (I know they say it will be Office 2009, but I
hope they've learned about rushing a half-baked product out the door).

I should point out that I am a Microsoft MVP, but that in no way should
indicate that I am employed or compensated by Microsoft. I am independent of
Microsoft except for the reliance of my livelihood upon Microsoft products.
I received the award for contributing to the community of Excel users
through forums like this.

- Jon
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com

"Ben Edwards" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...

Re: Excel 2007 line-chart pasted as an enhanced metafile - editing

Postby QmVuIEVkd2FyZHM » Mon, 08 Oct 2007 22:45:01 GMT

hanks again Jon, and points noted on your indepedence. Much appreciated

"Jon Peltier" wrote:

Similar Threads:

1.Editing a Table Pasted from Excel into Word as a Picture (Enhanced Metafile)


I am copying a section of an Excel Spreadsheet, and then pasting into
word using Paste Special -> Picture (Enhanced Metafile)

When I right click on the object in word, one of the menu choices is
"Edit Picture" This will allow me to change text in the picture, which
seems to be included through the use of text boxes.  I make a minor
change that is required, but then I cannot seem to revert the image or
picture back to its previous form, which seems to be as a normal
picture file that has been inserted.  The only way I can figure out
how to do this is by using the undo command, but I loose my text
chance.  If the picture stays in the new, editable format, whenever I
click into it, all of the text is becomes highlighted, which really
slows down my ability to continue work on the rest of the document.
The new format seems to be seen by word as a Drawing Canvas.

Does anyone know how I can make a text change, and then get Word to
see the image as an inserted picture file again as opposed to this
drawing canvas?


2.Font colours disappear when pasting to Powerpoint as Metafile/Enhanced metafile

When using copy/paste special to take a range from Excel 2002 to Powerpoint
2002 all is fine on my PCs - i.e. all formats are kept as expected.

However, my client has 2 of his own machines and 2 of his clients that lose
the font colour only - all text is black (background colours etc are fine).
Colour is retained in HTML and Bitmap formats but not Metafile or Enahnced

Anyone else had this problem?  If so, any solutions please.

3.Pasting Excel Charts as Enhanced Metafiles

Since upgrading to Office 2003, I am unable to 
successfully paste Graphs made in Excel as enhanced 
metafiles into my office's Microsoft Word report template.

When I paste special, as an enhanced metafile, I am only 
able to see the very bottom piece of the graph.  I can 
move the graph around and resize it, but it will not show 
up on screen.  Nor does it show up in print preview.  BUT 
it comes out just fine when I print a hard copy.

This issue is unique to our report template, as I can 
paste Excel graphs into a blank Word document with no 

But it is also unique to Excel, as I can successfully 
paste graphs made in Power Point into our report template.

I've tried re-creating the template in 2003 but that did 
not help.  I've also tried every combination of Office 
2000 and 2003 pastes (i.e. graphs made in Excel 2003 into 
the 2000 template, graphs made in Excel 2000 into the 2003 
template, etc).  Nothing seems to work.

Has anyone seen this problem before?  Any suggestions on 
how to get aorund it?

4.Pasting Excel Graphs (charts/enhanced metafile pictures) into Word

I am looking for a similar solution posted by Donahue, 
8/20/04, 7:07 am.

I have pasted excel charts and enhanced metafile pictures 
in a word document, sent this to a colleague who has Word 
2001 for the Mac, and she is unable to view these files.  
She sees a big (red?) X.

Size/memory is not an issue here.

Any help here?

5.Pasting excel as enhanced metafile

I usualy paste tables using from excel in to PP presentations as an enhanced 
metafile but recently these pictures are being pasted witha green boundary 
for no apparent reason. Any ideas ?

6. Pasting Excel cells as "Picture (Enhanced Metafile)"

7. Pasting from xl into word as an enhanced metafile

8. Microsoft Office 2003 and 2007 crashes when managing EMF (enhanced metafiles)

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 54 guest