| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can you adjust value text box in charts?
I'm having this problem that when I develop a pie chart with values then
decide to resize the chart the formatting of the value changes due to the text box around the value is fixed. For example if a piece of a pie chart was 44%, when I resize the chart to the size I require sometimes the % sign falls below the 44 and not beside it. This is not good quality when the charts are for publications. Alternatively, I could develop separate text boxes for each piece of pie but that is somewhat combersome. Does anyone have a solution? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can you adjust value text box in charts?
Hi Graeme,
Have you added these values as Data Labels? I have tried in both xl2002 and xl2007 and cannot replicate the problem using data labels. Also What version of xl are you using? -- Regards, OssieMac "Graeme" wrote: I'm having this problem that when I develop a pie chart with values then decide to resize the chart the formatting of the value changes due to the text box around the value is fixed. For example if a piece of a pie chart was 44%, when I resize the chart to the size I require sometimes the % sign falls below the 44 and not beside it. This is not good quality when the charts are for publications. Alternatively, I could develop separate text boxes for each piece of pie but that is somewhat combersome. Does anyone have a solution? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can you adjust value text box in charts?
Just another thought Graeme. If you are using data labels, after resizing,
select the data labels (just clicking on one of them should do it) and hit the delete key and then re-insert them and see what happens. -- Regards, OssieMac "OssieMac" wrote: Hi Graeme, Have you added these values as Data Labels? I have tried in both xl2002 and xl2007 and cannot replicate the problem using data labels. Also What version of xl are you using? -- Regards, OssieMac "Graeme" wrote: I'm having this problem that when I develop a pie chart with values then decide to resize the chart the formatting of the value changes due to the text box around the value is fixed. For example if a piece of a pie chart was 44%, when I resize the chart to the size I require sometimes the % sign falls below the 44 and not beside it. This is not good quality when the charts are for publications. Alternatively, I could develop separate text boxes for each piece of pie but that is somewhat combersome. Does anyone have a solution? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can you adjust value text box in charts?
OssieMac,
I deletied data label values and re-entered them however that didn't work. Currently running Windows XP and Excel 2003. "OssieMac" wrote: Just another thought Graeme. If you are using data labels, after resizing, select the data labels (just clicking on one of them should do it) and hit the delete key and then re-insert them and see what happens. -- Regards, OssieMac "OssieMac" wrote: Hi Graeme, Have you added these values as Data Labels? I have tried in both xl2002 and xl2007 and cannot replicate the problem using data labels. Also What version of xl are you using? -- Regards, OssieMac "Graeme" wrote: I'm having this problem that when I develop a pie chart with values then decide to resize the chart the formatting of the value changes due to the text box around the value is fixed. For example if a piece of a pie chart was 44%, when I resize the chart to the size I require sometimes the % sign falls below the 44 and not beside it. This is not good quality when the charts are for publications. Alternatively, I could develop separate text boxes for each piece of pie but that is somewhat combersome. Does anyone have a solution? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can you adjust value text box in charts?
Hi again Graeme,
Can you post a copy of the table of data and I'll try to replicate the pie chart and have a play with it?. I assume that you are trying to make the chart smaller; is that correct? -- Regards, OssieMac "Graeme" wrote: OssieMac, I deletied data label values and re-entered them however that didn't work. Currently running Windows XP and Excel 2003. "OssieMac" wrote: Just another thought Graeme. If you are using data labels, after resizing, select the data labels (just clicking on one of them should do it) and hit the delete key and then re-insert them and see what happens. -- Regards, OssieMac "OssieMac" wrote: Hi Graeme, Have you added these values as Data Labels? I have tried in both xl2002 and xl2007 and cannot replicate the problem using data labels. Also What version of xl are you using? -- Regards, OssieMac "Graeme" wrote: I'm having this problem that when I develop a pie chart with values then decide to resize the chart the formatting of the value changes due to the text box around the value is fixed. For example if a piece of a pie chart was 44%, when I resize the chart to the size I require sometimes the % sign falls below the 44 and not beside it. This is not good quality when the charts are for publications. Alternatively, I could develop separate text boxes for each piece of pie but that is somewhat combersome. Does anyone have a solution? |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can you adjust value text box in charts?
Hi OssieMac,
The data for one one the pie charts is pretty simple (as below). The problem occures when I develop a pie chart then shrink it down quite small. The report that we produce has numerous pie charts on a A4 sheet, so when they are shrunk down the % sign falls below the value section. Excel doesn't appear to allow manual changes to the value frame size i.e. stretching the frame across to allow the % sign to move back into its correct position. I could reduce the font size however it them become difficult to read when printed. Are you aware of any Excel add ins that improve the quality of charts? thanks Graeme CP customer = Single 35.5% CP customer = Partnered 64.5% "OssieMac" wrote: Hi again Graeme, Can you post a copy of the table of data and I'll try to replicate the pie chart and have a play with it?. I assume that you are trying to make the chart smaller; is that correct? -- Regards, OssieMac "Graeme" wrote: OssieMac, I deletied data label values and re-entered them however that didn't work. Currently running Windows XP and Excel 2003. "OssieMac" wrote: Just another thought Graeme. If you are using data labels, after resizing, select the data labels (just clicking on one of them should do it) and hit the delete key and then re-insert them and see what happens. -- Regards, OssieMac "OssieMac" wrote: Hi Graeme, Have you added these values as Data Labels? I have tried in both xl2002 and xl2007 and cannot replicate the problem using data labels. Also What version of xl are you using? -- Regards, OssieMac "Graeme" wrote: I'm having this problem that when I develop a pie chart with values then decide to resize the chart the formatting of the value changes due to the text box around the value is fixed. For example if a piece of a pie chart was 44%, when I resize the chart to the size I require sometimes the % sign falls below the 44 and not beside it. This is not good quality when the charts are for publications. Alternatively, I could develop separate text boxes for each piece of pie but that is somewhat combersome. Does anyone have a solution? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I set the row height to adjust to fit wrapped text | Excel Discussion (Misc queries) | |||
| automatically adjust charts | Charts and Charting in Excel | |||
| Text wrap does not adjust row height | Excel Discussion (Misc queries) | |||
| Row height to auto-adjust for wrapped text | Excel Discussion (Misc queries) | |||
| Automatically adjust cells to fit text | Excel Discussion (Misc queries) | |||
Hybrid Mode
