Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Losing Original Cell Format when pasting in cells | Excel Discussion (Misc queries) | |||
Pasting charts to Word from Excel as picture | Charts and Charting in Excel | |||
Pasting Excel charts into Word | Charts and Charting in Excel | |||
Pasting excel sheets with charts | Charts and Charting in Excel | |||
pasting into an excel template without losing the formatting | Excel Discussion (Misc queries) |