Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
EsN EsN is offline
external usenet poster
 
Posts: 3
Default Ungrouping a Bar Chart

I have a bar chart that I put into Powerpoint 2007. I have learned to ungroup
by copying and pasting special as a emf.
The problem I have is that it ungroups the labels and lines but the bars
still stay grouped together. Does anyone know how to get the bars to ungroup
from each other.

In 2003 this was very easy and useful to do, but in 2007 that functionality
went away.

Also is there a way to change individual bars into some with coloring like
slash marks or other types - not change the color gradient. This was also
available in 2003

--
EsN
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Ungrouping a Bar Chart

Finally someone else is complaining about that. This has bothered me since
the beta, and the bug report went unheeded. I can't believe that charts were
constructed in this way.

Here's one thing you can do. Format each bar separately before copying the
chart. When you ungroup, each bar will be a separate object in PowerPoint.
This approach will meet with only partial success. It is not possible (as
far as I can tell) to ungroup gridlines, axis ticks, and probably other
objects.

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


"EsN" wrote in message
...
I have a bar chart that I put into Powerpoint 2007. I have learned to
ungroup
by copying and pasting special as a emf.
The problem I have is that it ungroups the labels and lines but the bars
still stay grouped together. Does anyone know how to get the bars to
ungroup
from each other.

In 2003 this was very easy and useful to do, but in 2007 that
functionality
went away.

Also is there a way to change individual bars into some with coloring like
slash marks or other types - not change the color gradient. This was also
available in 2003

--
EsN



  #3   Report Post  
Posted to microsoft.public.excel.charting
EsN EsN is offline
external usenet poster
 
Posts: 3
Default Ungrouping a Bar Chart

Jon, this seems to work - I changed the color of the bars and then they could
be worked on separately - I saved as an emf and the lines and ticks and
labels are all ungrouped and you can change them as needed. At least it
appears this way.
Thanks!
--
EsN


"Jon Peltier" wrote:

Finally someone else is complaining about that. This has bothered me since
the beta, and the bug report went unheeded. I can't believe that charts were
constructed in this way.

Here's one thing you can do. Format each bar separately before copying the
chart. When you ungroup, each bar will be a separate object in PowerPoint.
This approach will meet with only partial success. It is not possible (as
far as I can tell) to ungroup gridlines, axis ticks, and probably other
objects.

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


"EsN" wrote in message
...
I have a bar chart that I put into Powerpoint 2007. I have learned to
ungroup
by copying and pasting special as a emf.
The problem I have is that it ungroups the labels and lines but the bars
still stay grouped together. Does anyone know how to get the bars to
ungroup
from each other.

In 2003 this was very easy and useful to do, but in 2007 that
functionality
went away.

Also is there a way to change individual bars into some with coloring like
slash marks or other types - not change the color gradient. This was also
available in 2003

--
EsN




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Missing Rows after Ungrouping [email protected] Excel Discussion (Misc queries) 1 July 17th 08 08:43 PM
ungrouping clip art FRUSTRATED AGAIN!! Excel Discussion (Misc queries) 0 November 20th 07 08:24 AM
After grouping & ungrouping a chart, I can no longer format it? Pro_D Mike Charts and Charting in Excel 0 October 5th 05 08:01 PM
Slow grouping and ungrouping since update Bruce H Excel Discussion (Misc queries) 0 June 1st 05 03:37 PM


All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"