Some charts won't let data labels to be at "Outside end"

[Kompu Kid]

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

 

[Jon Peltier]

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

 

[Kompu Kid]

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

 

[Jon Peltier]

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