ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Ungrouping a Bar Chart (https://www.excelbanter.com/charts-charting-excel/204741-ungrouping-bar-chart.html)

EsN

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

Jon Peltier

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




EsN

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






All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com