View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default 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?