View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Kompu Kid Kompu Kid is offline
external usenet poster
 
Posts: 19
Default Some charts won't let data labels to be at "Outside end"

I have exactly the same type of chart. One let's me choose the
location "Outside end", the other does not... That does not let me is
not a stacked bar or column chart, either. It is a real puzzle.


Deguza

On Jun 19, 5:35 am, "Jon Peltier"
wrote:
Outside End is only available for unstacked bar and column charts. Stacked
bar and column charts do not offer this option. In a non pivot chart you can
use an additional series, formatted to be invisible, to display these
labels. You can also move the labels manually, or use Rob Bovey's Chart
Labeler (http://appspro.com) to move a series of labels at once.

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

"Kompu Kid" wrote in message

ps.com...

Hello all:


In the same workbook I have several charts generated by pivot tables.


In one chart the data labels are at location "Outside end".


In the others under the "Label Position" "Outside end" does not show
as an option!


How so?


How do I fix this?


Deguza
Using excel 2003 (11.8117.8107) SP2
On Windows XP professional