Pivot Chart Data Label Format Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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.
 
You're welcome! Thanks for letting me know that the information on my
site has helped you.
 
Back
Top