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.

Pivot Chart Data Label Format Question
 

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

Pivot Chart Data Label Format Question
 

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

Pivot Chart Data Label Format Question
 

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