Excel 2007 chart line types
in [Charts]
|
Prev: how do I find a restaurant proforma spreadsheet
Next: adding trendline to plots from multiple series
From: Alan on 6 Jan 2010 12:57 Hi, When using Excel 2003, I was able to copy charts, and then paste them into CorelDraw as metafiles, ungroup these, and use the lines from the charts in my graphics. Since upgrading to Excel 2007, I am still able to do this, but the lines now appear to have a more complex format (the compund type is mentioned in the line properties dialog), made up of border and line types. On exporting to CoreDraw, these lines appear much less uniform than previously, changing thickness along the length of the line. Is there a workaround to allow me to plot chats with non-compund type lines as was possible in the previous version? Cheers! Submitted via EggHeadCafe - Software Developer Portal of Choice Book Review: Practical .NET2 and C#2 - by Patrick Smacchia http://www.eggheadcafe.com/tutorials/aspnet/dec2a779-a703-4e95-80cf-e9356835c4d7/book-review-practical-n.aspx
From: Bernard Liengme on 6 Jan 2010 15:15 Here is a suggestion (I cannot experiment as I do not have Corel Draw) Click the chart; on the Home tab, launch Paste and use As Picture Now you have used Excel to make a picture of the chart; go to Corel Draw and paste Does it look better? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Alan Sage" wrote in message news:201016125659alansageuk(a)yahoo.com... > Hi, > > > When using Excel 2003, I was able to copy charts, and then paste them into > CorelDraw as metafiles, ungroup these, and use the lines from the charts > in my graphics. Since upgrading to Excel 2007, I am still able to do > this, but the lines now appear to have a more complex format (the compund > type is mentioned in the line properties dialog), made up of border and > line types. On exporting to CoreDraw, these lines appear much less > uniform than previously, changing thickness along the length of the line. > Is there a workaround to allow me to plot chats with non-compund type > lines as was possible in the previous version? > > Cheers! > > > Submitted via EggHeadCafe - Software Developer Portal of Choice > Book Review: Practical .NET2 and C#2 - by Patrick Smacchia > http://www.eggheadcafe.com/tutorials/aspnet/dec2a779-a703-4e95-80cf-e9356835c4d7/book-review-practical-n.aspx
From: Mike Middleton on 6 Jan 2010 15:57
Alan Sage - In a previous thread, Jon Peltier reported "If it's any consolation, I have not been satisfied with Copy Picture in Excel," but maybe Excel 2007 SP2 has fixed some of the earlier problems. Try this: Select the chart (by clicking just inside its outside border), and choose Home | Paste | As Picture | Copy As Picture. Then try the three combinations of As Shown On Screen with Picture or Bitmap and As Shown When Printed. Click OK. Then paste into CorelDraw. - Mike http://www.MikeMiddleton.com "Alan Sage" wrote in message news:201016125659alansageuk(a)yahoo.com... Hi, When using Excel 2003, I was able to copy charts, and then paste them into CorelDraw as metafiles, ungroup these, and use the lines from the charts in my graphics. Since upgrading to Excel 2007, I am still able to do this, but the lines now appear to have a more complex format (the compund type is mentioned in the line properties dialog), made up of border and line types. On exporting to CoreDraw, these lines appear much less uniform than previously, changing thickness along the length of the line. Is there a workaround to allow me to plot chats with non-compund type lines as was possible in the previous version? Cheers! Submitted via EggHeadCafe - Software Developer Portal of Choice Book Review: Practical .NET2 and C#2 - by Patrick Smacchia http://www.eggheadcafe.com/tutorials/aspnet/dec2a779-a703-4e95-80cf-e9356835c4d7/book-review-practical-n.aspx |