Pivot Chart Data Label Format Question

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.

Dominic wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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" wrote:

> 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.
>
> Dominic wrote:
> > 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
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

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

Dominic wrote:
> 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" wrote:
>
>
>>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.
>>
>>Dominic wrote:
>>
>>>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
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html