Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pie explosion
i have created a pie chart using the chart type Pie Explosion. i am having
several formatting issues with this chart. 1. I have the following label Foundation (incl El Salvador). on the chart it appears with the parenthesis inverted like this - Foundation )incl El Salvador( 2. i can't seem to expand or contract the text boxes that contain the labels and title. i can move them, but not change their sizes. Thanks in advance for your help. -- aprilshowers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pie explosion
April -
i have created a pie chart using the chart type Pie Explosion. i am having several formatting issues with this chart. 1. I have the following label Foundation (incl El Salvador). on the chart it appears with the parenthesis inverted like this - Foundation )incl El Salvador( I've heard of this and seen screen shots, but I don't recall ever experiencing it directly. Perhaps if you adjust the font name or size? 2. i can't seem to expand or contract the text boxes that contain the labels and title. i can move them, but not change their sizes. This is the way data labels work, unfortunately. You could remove the data labels and add your own text boxes, which you can resize to suit. However, text boxes are static and don't move with the chart elements. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pie explosion
thank you - i assume that this holds true for version 2007.
-- aprilshowers "Jon Peltier" wrote: April - i have created a pie chart using the chart type Pie Explosion. i am having several formatting issues with this chart. 1. I have the following label Foundation (incl El Salvador). on the chart it appears with the parenthesis inverted like this - Foundation )incl El Salvador( I've heard of this and seen screen shots, but I don't recall ever experiencing it directly. Perhaps if you adjust the font name or size? 2. i can't seem to expand or contract the text boxes that contain the labels and title. i can move them, but not change their sizes. This is the way data labels work, unfortunately. You could remove the data labels and add your own text boxes, which you can resize to suit. However, text boxes are static and don't move with the chart elements. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
pie explosion
Yes, hardly anything was changed in Excel 2007 charting, except the dialogs
are less friendly, and you can overdo the formatting much more easily. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "april" wrote in message ... thank you - i assume that this holds true for version 2007. -- aprilshowers "Jon Peltier" wrote: April - i have created a pie chart using the chart type Pie Explosion. i am having several formatting issues with this chart. 1. I have the following label Foundation (incl El Salvador). on the chart it appears with the parenthesis inverted like this - Foundation )incl El Salvador( I've heard of this and seen screen shots, but I don't recall ever experiencing it directly. Perhaps if you adjust the font name or size? 2. i can't seem to expand or contract the text boxes that contain the labels and title. i can move them, but not change their sizes. This is the way data labels work, unfortunately. You could remove the data labels and add your own text boxes, which you can resize to suit. However, text boxes are static and don't move with the chart elements. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|