View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Some charts won't let data labels to be at "Outside end"

What kind of chart is it? How many series? If it has one series, stacked and
clustered versions of a bar or column chart are identical. Select the
series, go to Chart menu Chart Type, and see what is highlighted.

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


"Kompu Kid" wrote in message
oups.com...
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