ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Losing lines when pasting charts to Excel (https://www.excelbanter.com/excel-discussion-misc-queries/194570-losing-lines-when-pasting-charts-excel.html)

mrobles

Losing lines when pasting charts to Excel
 
I have created pie charts in Excel 2007. Most of them have thin slices that
require a line that points from the label to the correct slice. When I paste
these charts into Powerpoint 2007, I lose the label lines. Therefore, I have
labels floating in space and it's hard to tell what they're describing. I've
tried all the paste special options in Powerpoint and I still can't keep the
label lines. Please help.

Researcher08

Losing lines when pasting charts to Excel
 
simple, in powerpoint, go to: "insert"-"picture"-"auto shapes". select line,
and draw your label lines in powerpoint :)

"mrobles" wrote:

I have created pie charts in Excel 2007. Most of them have thin slices that
require a line that points from the label to the correct slice. When I paste
these charts into Powerpoint 2007, I lose the label lines. Therefore, I have
labels floating in space and it's hard to tell what they're describing. I've
tried all the paste special options in Powerpoint and I still can't keep the
label lines. Please help.


Jon Peltier

Losing lines when pasting charts to Excel
 
If you have very many pie segments, or some are so small that it's hard to
keep track of where labels should go, perhaps the pie chart is not the best
choice. Instead, try a horizontal bar chart. The labels will line up along
the vertical axis, and the bars will extend to the right. No bars or labels
will obscure any others.

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


"mrobles" wrote in message
...
I have created pie charts in Excel 2007. Most of them have thin slices that
require a line that points from the label to the correct slice. When I
paste
these charts into Powerpoint 2007, I lose the label lines. Therefore, I
have
labels floating in space and it's hard to tell what they're describing.
I've
tried all the paste special options in Powerpoint and I still can't keep
the
label lines. Please help.




mrobles

Losing lines when pasting charts to Excel
 
I appreciate the answer. But this seems like a bug to me. Even on charts
where I only needed 2 label lines, PowerPoint couldn't bring them over. Maybe
in the next version.

"Jon Peltier" wrote:

If you have very many pie segments, or some are so small that it's hard to
keep track of where labels should go, perhaps the pie chart is not the best
choice. Instead, try a horizontal bar chart. The labels will line up along
the vertical axis, and the bars will extend to the right. No bars or labels
will obscure any others.

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


"mrobles" wrote in message
...
I have created pie charts in Excel 2007. Most of them have thin slices that
require a line that points from the label to the correct slice. When I
paste
these charts into Powerpoint 2007, I lose the label lines. Therefore, I
have
labels floating in space and it's hard to tell what they're describing.
I've
tried all the paste special options in Powerpoint and I still can't keep
the
label lines. Please help.





mrobles

Losing lines when pasting charts to Excel
 
Good idea, but too time consuming when I have 40 charts that need multiple
label lines each. :)

"Researcher08" wrote:

simple, in powerpoint, go to: "insert"-"picture"-"auto shapes". select line,
and draw your label lines in powerpoint :)

"mrobles" wrote:

I have created pie charts in Excel 2007. Most of them have thin slices that
require a line that points from the label to the correct slice. When I paste
these charts into Powerpoint 2007, I lose the label lines. Therefore, I have
labels floating in space and it's hard to tell what they're describing. I've
tried all the paste special options in Powerpoint and I still can't keep the
label lines. Please help.


Jon Peltier

Losing lines when pasting charts to Excel
 
It worked in the version prior to 2007; 2007 has issues with charts and with
graphic displays. So it's likely a bug in 2007.

However, using an appropriate chart type will prevent the need to use
workarounds (leader lines) to label points.

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


"mrobles" wrote in message
...
I appreciate the answer. But this seems like a bug to me. Even on charts
where I only needed 2 label lines, PowerPoint couldn't bring them over.
Maybe
in the next version.

"Jon Peltier" wrote:

If you have very many pie segments, or some are so small that it's hard
to
keep track of where labels should go, perhaps the pie chart is not the
best
choice. Instead, try a horizontal bar chart. The labels will line up
along
the vertical axis, and the bars will extend to the right. No bars or
labels
will obscure any others.

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


"mrobles" wrote in message
...
I have created pie charts in Excel 2007. Most of them have thin slices
that
require a line that points from the label to the correct slice. When I
paste
these charts into Powerpoint 2007, I lose the label lines. Therefore, I
have
labels floating in space and it's hard to tell what they're describing.
I've
tried all the paste special options in Powerpoint and I still can't
keep
the
label lines. Please help.








All times are GMT +1. The time now is 02:43 PM.

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