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

  • Thread starter Thread starter Kompu Kid
  • Start date Start date
K

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
 
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
 
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
 
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
 
Back
Top