Pivot Chart Data Label Format Question

[Guest]

Hi All,

I'm running Excel 2K on Win 2K

I've created a Column Chart off of a pivot table. I chose "Show Values" on
the Data Labels tab of Format Data Series. The labels show up. On the
"Alignment" tab of Format Data Labels there is a "Label Position" drop down.
This drop down consists of "Inside End, Center, Inside Base", three choices.
None of these are what I want.

I created a new chart using the exact same procedure as above. However it
had a fourth option under "Label Position" called "Outside End". This is
exactly what I want.

My question is, and I feel stupid, is I can't get that "Outside End" option
to come up on my next chart.

Does anyone know what I might be doing wrong???

Thanks in advance.

 

[Debra Dalgleish]

If the chart type is clustered column, you'll have the Outside End
option for labels. If it's a stacked column, the option isn't available.

 

[Guest]

Thanks Debra.

I could have SWORN I tried that, but, as usual, you're right.

Thanks again. You've helped me TONS with your website and instructions to
others on this site.

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that the information on my
site has helped you.