A long time ago I think I could copy charts made in Excel into Powerpoint and
completely ungroup each chart and edit them (delete some elements, move
others etc).
When I try this now, it behaves like a non-ungroupable object, although one
can change the colour of bars etc using powerpoint controls.

I have tried looking it up in Help but no options that look like what I'm
asking appear/they use terms I don't recognise as what I need.
I am using Office 2007 editions of these programmes.
Thanks

In article <B0E4A7A5-0D0B-48EF-A1D0-(E-Mail Removed)>, MoC wrote:
> A long time ago I think I could copy charts made in Excel into Powerpoint and
> completely ungroup each chart and edit them (delete some elements, move
> others etc).
> When I try this now, it behaves like a non-ungroupable object, although one
> can change the colour of bars etc using powerpoint controls.

This has indeed changed in PPT 2007. Here's the workaround:

Select the chart then press Ctrl+C to copy it.
Then on the Home tab of the ribbon bar click the down-arrow beneath Paste and
choose Paste Special and pick Enhanced Metafile as the paste type.

You'll be able to ungroup the pasted graphic

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

PPT 2007 does not ungroup all of the chart like PPT 2003. You can ungroup
some of the axis lines and labels, but the main image comes in as a bitmap
image. Before in 2003, you could ungroup everything. If anyone else knows of
a way to ungroup everything like it was in PPT 2003, please share. This
change is very frustrating and disappointing.

"Steve Rindsberg" wrote:

> In article <B0E4A7A5-0D0B-48EF-A1D0-(E-Mail Removed)>, MoC wrote:
> > A long time ago I think I could copy charts made in Excel into Powerpoint and
> > completely ungroup each chart and edit them (delete some elements, move
> > others etc).
> > When I try this now, it behaves like a non-ungroupable object, although one
> > can change the colour of bars etc using powerpoint controls.
>
> This has indeed changed in PPT 2007. Here's the workaround:
>
> Select the chart then press Ctrl+C to copy it.
> Then on the Home tab of the ribbon bar click the down-arrow beneath Paste and
> choose Paste Special and pick Enhanced Metafile as the paste type.
>
> You'll be able to ungroup the pasted graphic
>
> -----------------------------------------
> Steve Rindsberg, PPT MVP
> PPT FAQ: www.pptfaq.com
> PPTools: www.pptools.com
> ================================================
>
>
>

In article <489273EC-3B11-4F85-BC8D-(E-Mail Removed)>, Blastboy88 wrote:
> PPT 2007 does not ungroup all of the chart like PPT 2003. You can ungroup
> some of the axis lines and labels, but the main image comes in as a bitmap
> image.

Arghhh. You're right.

> Before in 2003, you could ungroup everything. If anyone else knows of
> a way to ungroup everything like it was in PPT 2003, please share. This
> change is very frustrating and disappointing.
> "Steve Rindsberg" wrote:
>
> > In article <B0E4A7A5-0D0B-48EF-A1D0-(E-Mail Removed)>, MoC wrote:
> > > A long time ago I think I could copy charts made in Excel into Powerpoint and
> > > completely ungroup each chart and edit them (delete some elements, move
> > > others etc).
> > > When I try this now, it behaves like a non-ungroupable object, although one
> > > can change the colour of bars etc using powerpoint controls.
> >
> > This has indeed changed in PPT 2007. Here's the workaround:
> >
> > Select the chart then press Ctrl+C to copy it.
> > Then on the Home tab of the ribbon bar click the down-arrow beneath Paste and
> > choose Paste Special and pick Enhanced Metafile as the paste type.
> >
> > You'll be able to ungroup the pasted graphic
> >
> > -----------------------------------------
> > Steve Rindsberg, PPT MVP
> > PPT FAQ: www.pptfaq.com
> > PPTools: www.pptools.com
> > ================================================
> >
> >
> >
>

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

I've been having this problem ever since "upgrading" to Office 2007. For this
reason alone, I keep a copy of Excel 2003 installed on my computer.

For less important work (for me) like presentations I use Excel 2007 charts,
as they come with a bunch of pretty formats (shadows, 3D etc.) that Excel
2003 lacks. However, for important work like preparing journal
publication-quality charts, I'll plot the chart in Excel 2003, copy it and
paste-special-EMF into MS Visio, where I can completely ungroup all
components of the chart and tweak the formatting exactly how I want.
Ungrouped Excel 2007 charts cannot be as easily tweaked because typically the
data components (bars, columns etc.) ungroup into freeform objects which
cannot be further ungrouped. There's no solution to this problem that I've
been able to find so until MS fixes this (FIX IT MS!!!!) I'm gonna have to
stick with using Excel 2003 in addition to Excel 2007.

"Steve Rindsberg" wrote:

> In article <489273EC-3B11-4F85-BC8D-(E-Mail Removed)>, Blastboy88 wrote:
> > PPT 2007 does not ungroup all of the chart like PPT 2003. You can ungroup
> > some of the axis lines and labels, but the main image comes in as a bitmap
> > image.
>
> Arghhh. You're right.
>
> > Before in 2003, you could ungroup everything. If anyone else knows of
> > a way to ungroup everything like it was in PPT 2003, please share. This
> > change is very frustrating and disappointing.
> > "Steve Rindsberg" wrote:
> >
> > > In article <B0E4A7A5-0D0B-48EF-A1D0-(E-Mail Removed)>, MoC wrote:
> > > > A long time ago I think I could copy charts made in Excel into Powerpoint and
> > > > completely ungroup each chart and edit them (delete some elements, move
> > > > others etc).
> > > > When I try this now, it behaves like a non-ungroupable object, although one
> > > > can change the colour of bars etc using powerpoint controls.
> > >
> > > This has indeed changed in PPT 2007. Here's the workaround:
> > >
> > > Select the chart then press Ctrl+C to copy it.
> > > Then on the Home tab of the ribbon bar click the down-arrow beneath Paste and
> > > choose Paste Special and pick Enhanced Metafile as the paste type.
> > >
> > > You'll be able to ungroup the pasted graphic
> > >
> > > -----------------------------------------
> > > Steve Rindsberg, PPT MVP
> > > PPT FAQ: www.pptfaq.com
> > > PPTools: www.pptools.com
> > > ================================================
> > >
> > >
> > >
> >
>
> -----------------------------------------
> Steve Rindsberg, PPT MVP
> PPT FAQ: www.pptfaq.com
> PPTools: www.pptools.com
> ================================================
>
>
>

Trust me, they're aware of this issue, as many of us here struggle with the
exact same thing. When and if it will be *fixed,* however, is another
question entirely! (In other words, we feel your pain and also hope MS fixes
the ungrouping issues in PPT/Excel 2007.)

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


"Beau" <(E-Mail Removed)> wrote in message
news:1E27BD77-62E5-4E27-BEB6-(E-Mail Removed)...
> I've been having this problem ever since "upgrading" to Office 2007. For
> this
> reason alone, I keep a copy of Excel 2003 installed on my computer.
>
> For less important work (for me) like presentations I use Excel 2007
> charts,
> as they come with a bunch of pretty formats (shadows, 3D etc.) that Excel
> 2003 lacks. However, for important work like preparing journal
> publication-quality charts, I'll plot the chart in Excel 2003, copy it and
> paste-special-EMF into MS Visio, where I can completely ungroup all
> components of the chart and tweak the formatting exactly how I want.
> Ungrouped Excel 2007 charts cannot be as easily tweaked because typically
> the
> data components (bars, columns etc.) ungroup into freeform objects which
> cannot be further ungrouped. There's no solution to this problem that I've
> been able to find so until MS fixes this (FIX IT MS!!!!) I'm gonna have to
> stick with using Excel 2003 in addition to Excel 2007.
>
> "Steve Rindsberg" wrote:
>
>> In article <489273EC-3B11-4F85-BC8D-(E-Mail Removed)>,
>> Blastboy88 wrote:
>> > PPT 2007 does not ungroup all of the chart like PPT 2003. You can
>> > ungroup
>> > some of the axis lines and labels, but the main image comes in as a
>> > bitmap
>> > image.
>>
>> Arghhh. You're right.
>>
>> > Before in 2003, you could ungroup everything. If anyone else knows of
>> > a way to ungroup everything like it was in PPT 2003, please share. This
>> > change is very frustrating and disappointing.
>> > "Steve Rindsberg" wrote:
>> >
>> > > In article <B0E4A7A5-0D0B-48EF-A1D0-(E-Mail Removed)>, MoC
>> > > wrote:
>> > > > A long time ago I think I could copy charts made in Excel into
>> > > > Powerpoint and
>> > > > completely ungroup each chart and edit them (delete some elements,
>> > > > move
>> > > > others etc).
>> > > > When I try this now, it behaves like a non-ungroupable object,
>> > > > although one
>> > > > can change the colour of bars etc using powerpoint controls.
>> > >
>> > > This has indeed changed in PPT 2007. Here's the workaround:
>> > >
>> > > Select the chart then press Ctrl+C to copy it.
>> > > Then on the Home tab of the ribbon bar click the down-arrow beneath
>> > > Paste and
>> > > choose Paste Special and pick Enhanced Metafile as the paste type.
>> > >
>> > > You'll be able to ungroup the pasted graphic
>> > >
>> > > -----------------------------------------
>> > > Steve Rindsberg, PPT MVP
>> > > PPT FAQ: www.pptfaq.com
>> > > PPTools: www.pptools.com
>> > > ================================================
>> > >
>> > >
>> > >
>> >
>>
>> -----------------------------------------
>> Steve Rindsberg, PPT MVP
>> PPT FAQ: www.pptfaq.com
>> PPTools: www.pptools.com
>> ================================================
>>
>>
>>

When I ungroup the charts from the Enhanced Metafile format, each bar in my
bar graph has a think box (about 1.5 pt weight) around it and I cant seem to
reduce the weight. Is there any trick to this or is the only solution to
delete these boxes and then add an outline around the bars?



"Echo S" wrote:

> Trust me, they're aware of this issue, as many of us here struggle with the
> exact same thing. When and if it will be *fixed,* however, is another
> question entirely! (In other words, we feel your pain and also hope MS fixes
> the ungrouping issues in PPT/Excel 2007.)
>
> --
> Echo [MS PPT MVP] http://www.echosvoice.com
> What's new in PPT 2007? http://www.echosvoice.com/2007.htm
> Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
> PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx
>
>
> "Beau" <(E-Mail Removed)> wrote in message
> news:1E27BD77-62E5-4E27-BEB6-(E-Mail Removed)...
> > I've been having this problem ever since "upgrading" to Office 2007. For
> > this
> > reason alone, I keep a copy of Excel 2003 installed on my computer.
> >
> > For less important work (for me) like presentations I use Excel 2007
> > charts,
> > as they come with a bunch of pretty formats (shadows, 3D etc.) that Excel
> > 2003 lacks. However, for important work like preparing journal
> > publication-quality charts, I'll plot the chart in Excel 2003, copy it and
> > paste-special-EMF into MS Visio, where I can completely ungroup all
> > components of the chart and tweak the formatting exactly how I want.
> > Ungrouped Excel 2007 charts cannot be as easily tweaked because typically
> > the
> > data components (bars, columns etc.) ungroup into freeform objects which
> > cannot be further ungrouped. There's no solution to this problem that I've
> > been able to find so until MS fixes this (FIX IT MS!!!!) I'm gonna have to
> > stick with using Excel 2003 in addition to Excel 2007.
> >
> > "Steve Rindsberg" wrote:
> >
> >> In article <489273EC-3B11-4F85-BC8D-(E-Mail Removed)>,
> >> Blastboy88 wrote:
> >> > PPT 2007 does not ungroup all of the chart like PPT 2003. You can
> >> > ungroup
> >> > some of the axis lines and labels, but the main image comes in as a
> >> > bitmap
> >> > image.
> >>
> >> Arghhh. You're right.
> >>
> >> > Before in 2003, you could ungroup everything. If anyone else knows of
> >> > a way to ungroup everything like it was in PPT 2003, please share. This
> >> > change is very frustrating and disappointing.
> >> > "Steve Rindsberg" wrote:
> >> >
> >> > > In article <B0E4A7A5-0D0B-48EF-A1D0-(E-Mail Removed)>, MoC
> >> > > wrote:
> >> > > > A long time ago I think I could copy charts made in Excel into
> >> > > > Powerpoint and
> >> > > > completely ungroup each chart and edit them (delete some elements,
> >> > > > move
> >> > > > others etc).
> >> > > > When I try this now, it behaves like a non-ungroupable object,
> >> > > > although one
> >> > > > can change the colour of bars etc using powerpoint controls.
> >> > >
> >> > > This has indeed changed in PPT 2007. Here's the workaround:
> >> > >
> >> > > Select the chart then press Ctrl+C to copy it.
> >> > > Then on the Home tab of the ribbon bar click the down-arrow beneath
> >> > > Paste and
> >> > > choose Paste Special and pick Enhanced Metafile as the paste type.
> >> > >
> >> > > You'll be able to ungroup the pasted graphic
> >> > >
> >> > > -----------------------------------------
> >> > > Steve Rindsberg, PPT MVP
> >> > > PPT FAQ: www.pptfaq.com
> >> > > PPTools: www.pptools.com
> >> > > ================================================
> >> > >
> >> > >
> >> > >
> >> >
> >>
> >> -----------------------------------------
> >> Steve Rindsberg, PPT MVP
> >> PPT FAQ: www.pptfaq.com
> >> PPTools: www.pptools.com
> >> ================================================
> >>
> >>
> >>
>
>

They've been upgrouped as much as possible. These "borders" are actually
boxes with 1.5pt borders and no color filling layered on top of the colored
boxes of the bar graphs. (I am working with one dimensional horizontal and
vertical bar charts, containing multiple categories and miltiple series that
we're made in 2003.) One thing I've noticed is that when I ungroup these
2003 charts I get the categories AND series ungrouped. But, when I make
charts in the new 2007 version, and then paste special, metafile I can't seem
to get the SERIES to ungroup.

"Steve Rindsberg" wrote:

> In article <BD10DB92-43FF-4156-9811-(E-Mail Removed)>, Basemrg wrote:
> > When I ungroup the charts from the Enhanced Metafile format, each bar in my
> > bar graph has a think box (about 1.5 pt weight) around it and I cant seem to
> > reduce the weight. Is there any trick to this or is the only solution to
> > delete these boxes and then add an outline around the bars?
>
> Sometimes you need to ungroup multiple times to get things to the point where you
> can select the individual bits you want to modify. Give that a try and let us
> know how it works out.
>
> >
> > "Echo S" wrote:
> >
> > > Trust me, they're aware of this issue, as many of us here struggle with the
> > > exact same thing. When and if it will be *fixed,* however, is another
> > > question entirely! (In other words, we feel your pain and also hope MS fixes
> > > the ungrouping issues in PPT/Excel 2007.)
> > >
> > > --
> > > Echo [MS PPT MVP] http://www.echosvoice.com
> > > What's new in PPT 2007? http://www.echosvoice.com/2007.htm
> > > Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
> > > PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx
> > >
> > >
> > > "Beau" <(E-Mail Removed)> wrote in message
> > > news:1E27BD77-62E5-4E27-BEB6-(E-Mail Removed)...
> > > > I've been having this problem ever since "upgrading" to Office 2007. For
> > > > this
> > > > reason alone, I keep a copy of Excel 2003 installed on my computer.
> > > >
> > > > For less important work (for me) like presentations I use Excel 2007
> > > > charts,
> > > > as they come with a bunch of pretty formats (shadows, 3D etc.) that Excel
> > > > 2003 lacks. However, for important work like preparing journal
> > > > publication-quality charts, I'll plot the chart in Excel 2003, copy it and
> > > > paste-special-EMF into MS Visio, where I can completely ungroup all
> > > > components of the chart and tweak the formatting exactly how I want.
> > > > Ungrouped Excel 2007 charts cannot be as easily tweaked because typically
> > > > the
> > > > data components (bars, columns etc.) ungroup into freeform objects which
> > > > cannot be further ungrouped. There's no solution to this problem that I've
> > > > been able to find so until MS fixes this (FIX IT MS!!!!) I'm gonna have to
> > > > stick with using Excel 2003 in addition to Excel 2007.
> > > >
> > > > "Steve Rindsberg" wrote:
> > > >
> > > >> In article <489273EC-3B11-4F85-BC8D-(E-Mail Removed)>,
> > > >> Blastboy88 wrote:
> > > >> > PPT 2007 does not ungroup all of the chart like PPT 2003. You can
> > > >> > ungroup
> > > >> > some of the axis lines and labels, but the main image comes in as a
> > > >> > bitmap
> > > >> > image.
> > > >>
> > > >> Arghhh. You're right.
> > > >>
> > > >> > Before in 2003, you could ungroup everything. If anyone else knows of
> > > >> > a way to ungroup everything like it was in PPT 2003, please share. This
> > > >> > change is very frustrating and disappointing.
> > > >> > "Steve Rindsberg" wrote:
> > > >> >
> > > >> > > In article <B0E4A7A5-0D0B-48EF-A1D0-(E-Mail Removed)>, MoC
> > > >> > > wrote:
> > > >> > > > A long time ago I think I could copy charts made in Excel into
> > > >> > > > Powerpoint and
> > > >> > > > completely ungroup each chart and edit them (delete some elements,
> > > >> > > > move
> > > >> > > > others etc).
> > > >> > > > When I try this now, it behaves like a non-ungroupable object,
> > > >> > > > although one
> > > >> > > > can change the colour of bars etc using powerpoint controls.
> > > >> > >
> > > >> > > This has indeed changed in PPT 2007. Here's the workaround:
> > > >> > >
> > > >> > > Select the chart then press Ctrl+C to copy it.
> > > >> > > Then on the Home tab of the ribbon bar click the down-arrow beneath
> > > >> > > Paste and
> > > >> > > choose Paste Special and pick Enhanced Metafile as the paste type.
> > > >> > >
> > > >> > > You'll be able to ungroup the pasted graphic
> > > >> > >
> > > >> > > -----------------------------------------
> > > >> > > Steve Rindsberg, PPT MVP
> > > >> > > PPT FAQ: www.pptfaq.com
> > > >> > > PPTools: www.pptools.com
> > > >> > > ================================================
> > > >> > >
> > > >> > >
> > > >> > >
> > > >> >
> > > >>
> > > >> -----------------------------------------
> > > >> Steve Rindsberg, PPT MVP
> > > >> PPT FAQ: www.pptfaq.com
> > > >> PPTools: www.pptools.com
> > > >> ================================================
> > > >>
> > > >>
> > > >>
> > >
> > >
>
>
> ==============================
> PPT Frequently Asked Questions
> http://www.pptfaq.com/
>
> PPTools add-ins for PowerPoint
> http://www.pptools.com/
>
>

Hm. I can't repro the lines. What style of chart are you using? That is, how
is it formatted before you ungroup it?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


"basemrg" <(E-Mail Removed)> wrote in message
news:C443D23A-350E-42E6-ABA9-(E-Mail Removed)...
> They've been upgrouped as much as possible. These "borders" are actually
> boxes with 1.5pt borders and no color filling layered on top of the
> colored
> boxes of the bar graphs. (I am working with one dimensional horizontal
> and
> vertical bar charts, containing multiple categories and miltiple series
> that
> we're made in 2003.) One thing I've noticed is that when I ungroup these
> 2003 charts I get the categories AND series ungrouped. But, when I make
> charts in the new 2007 version, and then paste special, metafile I can't
> seem
> to get the SERIES to ungroup.
>
> "Steve Rindsberg" wrote:
>
>> In article <BD10DB92-43FF-4156-9811-(E-Mail Removed)>, Basemrg
>> wrote:
>> > When I ungroup the charts from the Enhanced Metafile format, each bar
>> > in my
>> > bar graph has a think box (about 1.5 pt weight) around it and I cant
>> > seem to
>> > reduce the weight. Is there any trick to this or is the only solution
>> > to
>> > delete these boxes and then add an outline around the bars?
>>
>> Sometimes you need to ungroup multiple times to get things to the point
>> where you
>> can select the individual bits you want to modify. Give that a try and
>> let us
>> know how it works out.
>>
>> >
>> > "Echo S" wrote:
>> >
>> > > Trust me, they're aware of this issue, as many of us here struggle
>> > > with the
>> > > exact same thing. When and if it will be *fixed,* however, is another
>> > > question entirely! (In other words, we feel your pain and also hope
>> > > MS fixes
>> > > the ungrouping issues in PPT/Excel 2007.)
>> > >
>> > > --
>> > > Echo [MS PPT MVP] http://www.echosvoice.com
>> > > What's new in PPT 2007? http://www.echosvoice.com/2007.htm
>> > > Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
>> > > PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx
>> > >
>> > >
>> > > "Beau" <(E-Mail Removed)> wrote in message
>> > > news:1E27BD77-62E5-4E27-BEB6-(E-Mail Removed)...
>> > > > I've been having this problem ever since "upgrading" to Office
>> > > > 2007. For
>> > > > this
>> > > > reason alone, I keep a copy of Excel 2003 installed on my computer.
>> > > >
>> > > > For less important work (for me) like presentations I use Excel
>> > > > 2007
>> > > > charts,
>> > > > as they come with a bunch of pretty formats (shadows, 3D etc.) that
>> > > > Excel
>> > > > 2003 lacks. However, for important work like preparing journal
>> > > > publication-quality charts, I'll plot the chart in Excel 2003, copy
>> > > > it and
>> > > > paste-special-EMF into MS Visio, where I can completely ungroup all
>> > > > components of the chart and tweak the formatting exactly how I
>> > > > want.
>> > > > Ungrouped Excel 2007 charts cannot be as easily tweaked because
>> > > > typically
>> > > > the
>> > > > data components (bars, columns etc.) ungroup into freeform objects
>> > > > which
>> > > > cannot be further ungrouped. There's no solution to this problem
>> > > > that I've
>> > > > been able to find so until MS fixes this (FIX IT MS!!!!) I'm gonna
>> > > > have to
>> > > > stick with using Excel 2003 in addition to Excel 2007.
>> > > >
>> > > > "Steve Rindsberg" wrote:
>> > > >
>> > > >> In article <489273EC-3B11-4F85-BC8D-(E-Mail Removed)>,
>> > > >> Blastboy88 wrote:
>> > > >> > PPT 2007 does not ungroup all of the chart like PPT 2003. You
>> > > >> > can
>> > > >> > ungroup
>> > > >> > some of the axis lines and labels, but the main image comes in
>> > > >> > as a
>> > > >> > bitmap
>> > > >> > image.
>> > > >>
>> > > >> Arghhh. You're right.
>> > > >>
>> > > >> > Before in 2003, you could ungroup everything. If anyone else
>> > > >> > knows of
>> > > >> > a way to ungroup everything like it was in PPT 2003, please
>> > > >> > share. This
>> > > >> > change is very frustrating and disappointing.
>> > > >> > "Steve Rindsberg" wrote:
>> > > >> >
>> > > >> > > In article
>> > > >> > > <B0E4A7A5-0D0B-48EF-A1D0-(E-Mail Removed)>, MoC
>> > > >> > > wrote:
>> > > >> > > > A long time ago I think I could copy charts made in Excel
>> > > >> > > > into
>> > > >> > > > Powerpoint and
>> > > >> > > > completely ungroup each chart and edit them (delete some
>> > > >> > > > elements,
>> > > >> > > > move
>> > > >> > > > others etc).
>> > > >> > > > When I try this now, it behaves like a non-ungroupable
>> > > >> > > > object,
>> > > >> > > > although one
>> > > >> > > > can change the colour of bars etc using powerpoint controls.
>> > > >> > >
>> > > >> > > This has indeed changed in PPT 2007. Here's the workaround:
>> > > >> > >
>> > > >> > > Select the chart then press Ctrl+C to copy it.
>> > > >> > > Then on the Home tab of the ribbon bar click the down-arrow
>> > > >> > > beneath
>> > > >> > > Paste and
>> > > >> > > choose Paste Special and pick Enhanced Metafile as the paste
>> > > >> > > type.
>> > > >> > >
>> > > >> > > You'll be able to ungroup the pasted graphic
>> > > >> > >
>> > > >> > > -----------------------------------------
>> > > >> > > Steve Rindsberg, PPT MVP
>> > > >> > > PPT FAQ: www.pptfaq.com
>> > > >> > > PPTools: www.pptools.com
>> > > >> > > ================================================
>> > > >> > >
>> > > >> > >
>> > > >> > >
>> > > >> >
>> > > >>
>> > > >> -----------------------------------------
>> > > >> Steve Rindsberg, PPT MVP
>> > > >> PPT FAQ: www.pptfaq.com
>> > > >> PPTools: www.pptools.com
>> > > >> ================================================
>> > > >>
>> > > >>
>> > > >>
>> > >
>> > >
>>
>>
>> ==============================
>> PPT Frequently Asked Questions
>> http://www.pptfaq.com/
>>
>> PPTools add-ins for PowerPoint
>> http://www.pptools.com/
>>
>>

I can't repro. What formatting are you guys using for the chart?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


"Steve Rindsberg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I see what you mean and can repro here. I know this has been reported to
>MS so
> they're aware of it; I was hoping it'd be fixed in SP2 but unfortunately
> it hasn't.
>
> If you have Corel Draw, you can paste as EMF into it, ungroup all then
> choose a series
> and use Break Curve Apart to convert it into individually editable shapes.
>
>
>
> In article <C443D23A-350E-42E6-ABA9-(E-Mail Removed)>, Basemrg
> wrote:
>> They've been upgrouped as much as possible. These "borders" are actually
>> boxes with 1.5pt borders and no color filling layered on top of the
>> colored
>> boxes of the bar graphs. (I am working with one dimensional horizontal
>> and
>> vertical bar charts, containing multiple categories and miltiple series
>> that
>> we're made in 2003.) One thing I've noticed is that when I ungroup these
>> 2003 charts I get the categories AND series ungrouped. But, when I make
>> charts in the new 2007 version, and then paste special, metafile I can't
>> seem
>> to get the SERIES to ungroup.
>>
>> "Steve Rindsberg" wrote:
>>
>> > In article <BD10DB92-43FF-4156-9811-(E-Mail Removed)>,
>> > Basemrg wrote:
>> > > When I ungroup the charts from the Enhanced Metafile format, each bar
>> > > in my
>> > > bar graph has a think box (about 1.5 pt weight) around it and I cant
>> > > seem to
>> > > reduce the weight. Is there any trick to this or is the only
>> > > solution to
>> > > delete these boxes and then add an outline around the bars?
>> >
>> > Sometimes you need to ungroup multiple times to get things to the point
>> > where you
>> > can select the individual bits you want to modify. Give that a try and
>> > let us
>> > know how it works out.
>> >
>> > >
>> > > "Echo S" wrote:
>> > >
>> > > > Trust me, they're aware of this issue, as many of us here struggle
>> > > > with the
>> > > > exact same thing. When and if it will be *fixed,* however, is
>> > > > another
>> > > > question entirely! (In other words, we feel your pain and also hope
>> > > > MS fixes
>> > > > the ungrouping issues in PPT/Excel 2007.)
>> > > >
>> > > > --
>> > > > Echo [MS PPT MVP] http://www.echosvoice.com
>> > > > What's new in PPT 2007? http://www.echosvoice.com/2007.htm
>> > > > Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
>> > > > PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx
>> > > >
>> > > >
>> > > > "Beau" <(E-Mail Removed)> wrote in message
>> > > > news:1E27BD77-62E5-4E27-BEB6-(E-Mail Removed)...
>> > > > > I've been having this problem ever since "upgrading" to Office
>> > > > > 2007. For
>> > > > > this
>> > > > > reason alone, I keep a copy of Excel 2003 installed on my
>> > > > > computer.
>> > > > >
>> > > > > For less important work (for me) like presentations I use Excel
>> > > > > 2007
>> > > > > charts,
>> > > > > as they come with a bunch of pretty formats (shadows, 3D etc.)
>> > > > > that Excel
>> > > > > 2003 lacks. However, for important work like preparing journal
>> > > > > publication-quality charts, I'll plot the chart in Excel 2003,
>> > > > > copy it and
>> > > > > paste-special-EMF into MS Visio, where I can completely ungroup
>> > > > > all
>> > > > > components of the chart and tweak the formatting exactly how I
>> > > > > want.
>> > > > > Ungrouped Excel 2007 charts cannot be as easily tweaked because
>> > > > > typically
>> > > > > the
>> > > > > data components (bars, columns etc.) ungroup into freeform
>> > > > > objects which
>> > > > > cannot be further ungrouped. There's no solution to this problem
>> > > > > that I've
>> > > > > been able to find so until MS fixes this (FIX IT MS!!!!) I'm
>> > > > > gonna have to
>> > > > > stick with using Excel 2003 in addition to Excel 2007.
>> > > > >
>> > > > > "Steve Rindsberg" wrote:
>> > > > >
>> > > > >> In article <489273EC-3B11-4F85-BC8D-(E-Mail Removed)>,
>> > > > >> Blastboy88 wrote:
>> > > > >> > PPT 2007 does not ungroup all of the chart like PPT 2003. You
>> > > > >> > can
>> > > > >> > ungroup
>> > > > >> > some of the axis lines and labels, but the main image comes in
>> > > > >> > as a
>> > > > >> > bitmap
>> > > > >> > image.
>> > > > >>
>> > > > >> Arghhh. You're right.
>> > > > >>
>> > > > >> > Before in 2003, you could ungroup everything. If anyone else
>> > > > >> > knows of
>> > > > >> > a way to ungroup everything like it was in PPT 2003, please
>> > > > >> > share. This
>> > > > >> > change is very frustrating and disappointing.
>> > > > >> > "Steve Rindsberg" wrote:
>> > > > >> >
>> > > > >> > > In article
>> > > > >> > > <B0E4A7A5-0D0B-48EF-A1D0-(E-Mail Removed)>, MoC
>> > > > >> > > wrote:
>> > > > >> > > > A long time ago I think I could copy charts made in Excel
>> > > > >> > > > into
>> > > > >> > > > Powerpoint and
>> > > > >> > > > completely ungroup each chart and edit them (delete some
>> > > > >> > > > elements,
>> > > > >> > > > move
>> > > > >> > > > others etc).
>> > > > >> > > > When I try this now, it behaves like a non-ungroupable
>> > > > >> > > > object,
>> > > > >> > > > although one
>> > > > >> > > > can change the colour of bars etc using powerpoint
>> > > > >> > > > controls.
>> > > > >> > >
>> > > > >> > > This has indeed changed in PPT 2007. Here's the workaround:
>> > > > >> > >
>> > > > >> > > Select the chart then press Ctrl+C to copy it.
>> > > > >> > > Then on the Home tab of the ribbon bar click the down-arrow
>> > > > >> > > beneath
>> > > > >> > > Paste and
>> > > > >> > > choose Paste Special and pick Enhanced Metafile as the paste
>> > > > >> > > type.
>> > > > >> > >
>> > > > >> > > You'll be able to ungroup the pasted graphic
>> > > > >> > >
>> > > > >> > > -----------------------------------------
>> > > > >> > > Steve Rindsberg, PPT MVP
>> > > > >> > > PPT FAQ: www.pptfaq.com
>> > > > >> > > PPTools: www.pptools.com
>> > > > >> > > ================================================
>> > > > >> > >
>> > > > >> > >
>> > > > >> > >
>> > > > >> >
>> > > > >>
>> > > > >> -----------------------------------------
>> > > > >> Steve Rindsberg, PPT MVP
>> > > > >> PPT FAQ: www.pptfaq.com
>> > > > >> PPTools: www.pptools.com
>> > > > >> ================================================
>> > > > >>
>> > > > >>
>> > > > >>
>> > > >
>> > > >
>> >
>> >
>> > ==============================
>> > PPT Frequently Asked Questions
>> > http://www.pptfaq.com/
>> >
>> > PPTools add-ins for PowerPoint
>> > http://www.pptools.com/
>> >
>> >
>
>
> ==============================
> PPT Frequently Asked Questions
> http://www.pptfaq.com/
>
> PPTools add-ins for PowerPoint
> http://www.pptools.com/
>