Group:  Microsoft Excel ยป microsoft.public.excel.charting
Thread: Need vectors exported from Office/Excel Chart

Geek News

Need vectors exported from Office/Excel Chart
JGBarin 12/10/2008 10:13:01 PM
I'm needing to export high-resolution graphics from Excel, charts from my
data for professional publication at 600 dpi.

I used to be able to copy-paste Office graphs as vector graphics into
Photoshop or Illustrator (my preferred platforms for final finishing on
graphics).

However, the Chart app in Office 2007 seems to dump low-resolution rasters
into anything that's not Office.

Powerpoint, Word, nor any other Microsoft product I've encountered are
acceptable substitutes.

Any ideas on how to get Office to export charts as high-resolution vectors?
Re: Need vectors exported from Office/Excel Chart
"Jon Peltier" <jonxlmvpNO[ at ]SPAMpeltiertech.com> 12/11/2008 3:59:53 AM
You can copy an Excel 2007 chart as a picture, but you have to hunt for the
command. Click on the big ugly Paste button's dropdown, choose As Picture,
then Copy As Picture (well hidden, eh?). Choose the On Screen and Picture
options. This will copy a metafile to the clipboard.

Even as a metafile, I find the visual appearance of these objects in 2007 to
be hugely inferior to the equivalent in 2003 and earlier.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"JGBarin" <JGBarin[ at ]discussions.microsoft.com> wrote in message
news:7A5FCFB8-F323-4DD4-890B-13B3B8677B02[ at ]microsoft.com...
[Quoted Text]
> I'm needing to export high-resolution graphics from Excel, charts from my
> data for professional publication at 600 dpi.
>
> I used to be able to copy-paste Office graphs as vector graphics into
> Photoshop or Illustrator (my preferred platforms for final finishing on
> graphics).
>
> However, the Chart app in Office 2007 seems to dump low-resolution rasters
> into anything that's not Office.
>
> Powerpoint, Word, nor any other Microsoft product I've encountered are
> acceptable substitutes.
>
> Any ideas on how to get Office to export charts as high-resolution
> vectors?


Re: Need vectors exported from Office/Excel Chart
JGBarin 12/15/2008 4:03:03 PM
Greetings, and thanks for the tip.

When I use the Copy As Picture function, I find that the axes titles are
askew, misaligned, and unusably illegible.

It seems to happen if I use either the 'As Shown On Screen'->Picture or
'As Shown in Picture' options.

Ideas?

"Jon Peltier" wrote:

[Quoted Text]
> You can copy an Excel 2007 chart as a picture, but you have to hunt for the
> command. Click on the big ugly Paste button's dropdown, choose As Picture,
> then Copy As Picture (well hidden, eh?). Choose the On Screen and Picture
> options. This will copy a metafile to the clipboard.
>
> Even as a metafile, I find the visual appearance of these objects in 2007 to
> be hugely inferior to the equivalent in 2003 and earlier.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services, Inc.
> http://PeltierTech.com/WordPress/
> _______
>
>
> "JGBarin" <JGBarin[ at ]discussions.microsoft.com> wrote in message
> news:7A5FCFB8-F323-4DD4-890B-13B3B8677B02[ at ]microsoft.com...
> > I'm needing to export high-resolution graphics from Excel, charts from my
> > data for professional publication at 600 dpi.
> >
> > I used to be able to copy-paste Office graphs as vector graphics into
> > Photoshop or Illustrator (my preferred platforms for final finishing on
> > graphics).
> >
> > However, the Chart app in Office 2007 seems to dump low-resolution rasters
> > into anything that's not Office.
> >
> > Powerpoint, Word, nor any other Microsoft product I've encountered are
> > acceptable substitutes.
> >
> > Any ideas on how to get Office to export charts as high-resolution
> > vectors?
>
>
>
Re: Need vectors exported from Office/Excel Chart
"Jon Peltier" <jonxlmvpNO[ at ]SPAMpeltiertech.com> 12/15/2008 10:08:09 PM
You don't still have a copy of 2003, do you? I've been disappointed in any
exported chart format in 2007.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"JGBarin" <JGBarin[ at ]discussions.microsoft.com> wrote in message
news:49E9D703-01A7-4F3A-BB8B-BB82766C037F[ at ]microsoft.com...
[Quoted Text]
> Greetings, and thanks for the tip.
>
> When I use the Copy As Picture function, I find that the axes titles are
> askew, misaligned, and unusably illegible.
>
> It seems to happen if I use either the 'As Shown On Screen'->Picture or
> 'As Shown in Picture' options.
>
> Ideas?
>
> "Jon Peltier" wrote:
>
>> You can copy an Excel 2007 chart as a picture, but you have to hunt for
>> the
>> command. Click on the big ugly Paste button's dropdown, choose As
>> Picture,
>> then Copy As Picture (well hidden, eh?). Choose the On Screen and Picture
>> options. This will copy a metafile to the clipboard.
>>
>> Even as a metafile, I find the visual appearance of these objects in 2007
>> to
>> be hugely inferior to the equivalent in 2003 and earlier.
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Peltier Technical Services, Inc.
>> http://PeltierTech.com/WordPress/
>> _______
>>
>>
>> "JGBarin" <JGBarin[ at ]discussions.microsoft.com> wrote in message
>> news:7A5FCFB8-F323-4DD4-890B-13B3B8677B02[ at ]microsoft.com...
>> > I'm needing to export high-resolution graphics from Excel, charts from
>> > my
>> > data for professional publication at 600 dpi.
>> >
>> > I used to be able to copy-paste Office graphs as vector graphics into
>> > Photoshop or Illustrator (my preferred platforms for final finishing on
>> > graphics).
>> >
>> > However, the Chart app in Office 2007 seems to dump low-resolution
>> > rasters
>> > into anything that's not Office.
>> >
>> > Powerpoint, Word, nor any other Microsoft product I've encountered are
>> > acceptable substitutes.
>> >
>> > Any ideas on how to get Office to export charts as high-resolution
>> > vectors?
>>
>>
>>


Re: Need vectors exported from Office/Excel Chart
JGBarin 12/30/2008 9:37:35 PM
Sadly, no. Trickiness with the institutional license, and all.

I'll remember to add this to my already monstrous list of Downgrades in
Office.

And thanks for the help.

"Jon Peltier" wrote:

[Quoted Text]
> You don't still have a copy of 2003, do you? I've been disappointed in any
> exported chart format in 2007.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services, Inc.
> http://PeltierTech.com/WordPress/
> _______
>
>
> "JGBarin" <JGBarin[ at ]discussions.microsoft.com> wrote in message
> news:49E9D703-01A7-4F3A-BB8B-BB82766C037F[ at ]microsoft.com...
> > Greetings, and thanks for the tip.
> >
> > When I use the Copy As Picture function, I find that the axes titles are
> > askew, misaligned, and unusably illegible.
> >
> > It seems to happen if I use either the 'As Shown On Screen'->Picture or
> > 'As Shown in Picture' options.
> >
> > Ideas?
> >
> > "Jon Peltier" wrote:
> >
> >> You can copy an Excel 2007 chart as a picture, but you have to hunt for
> >> the
> >> command. Click on the big ugly Paste button's dropdown, choose As
> >> Picture,
> >> then Copy As Picture (well hidden, eh?). Choose the On Screen and Picture
> >> options. This will copy a metafile to the clipboard.
> >>
> >> Even as a metafile, I find the visual appearance of these objects in 2007
> >> to
> >> be hugely inferior to the equivalent in 2003 and earlier.
> >>
> >> - Jon
> >> -------
> >> Jon Peltier, Microsoft Excel MVP
> >> Peltier Technical Services, Inc.
> >> http://PeltierTech.com/WordPress/
> >> _______
> >>
> >>
> >> "JGBarin" <JGBarin[ at ]discussions.microsoft.com> wrote in message
> >> news:7A5FCFB8-F323-4DD4-890B-13B3B8677B02[ at ]microsoft.com...
> >> > I'm needing to export high-resolution graphics from Excel, charts from
> >> > my
> >> > data for professional publication at 600 dpi.
> >> >
> >> > I used to be able to copy-paste Office graphs as vector graphics into
> >> > Photoshop or Illustrator (my preferred platforms for final finishing on
> >> > graphics).
> >> >
> >> > However, the Chart app in Office 2007 seems to dump low-resolution
> >> > rasters
> >> > into anything that's not Office.
> >> >
> >> > Powerpoint, Word, nor any other Microsoft product I've encountered are
> >> > acceptable substitutes.
> >> >
> >> > Any ideas on how to get Office to export charts as high-resolution
> >> > vectors?
> >>
> >>
> >>
>
>
>

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net