Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 8th 09, 01:10 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 68
Default Data Series Label Positioning

Excel 2007

I have an bar chart that has vertically oriented data labels that are
centered on each bar of the chart. I need to reproduce that for another
chart, but I'm having a hard time figuring out how I got it to work the
first time. I know how to add the series label to the chart and to flip the
labels vertically, but the labels all appear above the bar instead of being
centered within the bar. How do I get the series labels to automatically
center within each bar?

Thanks for any insight that you can provide.

--Tom



  #2   Report Post  
Old May 8th 09, 08:49 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default Data Series Label Positioning

Hi,

Select the data labels. CTRL+1 to display format dialog.
Select Label Options
Label Position Center

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Thomas M." wrote in message
...
Excel 2007

I have an bar chart that has vertically oriented data labels that are
centered on each bar of the chart. I need to reproduce that for another
chart, but I'm having a hard time figuring out how I got it to work the
first time. I know how to add the series label to the chart and to flip
the labels vertically, but the labels all appear above the bar instead of
being centered within the bar. How do I get the series labels to
automatically center within each bar?

Thanks for any insight that you can provide.

--Tom


  #3   Report Post  
Old May 8th 09, 07:37 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 68
Default Data Series Label Positioning

I don't see a "Label Position" option. I *do* see an option for alignment,
which is where you set the horizontal alignment and text direction, but I
see nothing for vertical alignment. I thought that maybe the number was too
large to fit within the bar, so as a test I dummied up the data to make it a
small number so that there would be plenty of room for the number to fit
inside the bar, but it still displays above the bar.

--Tom

"Andy Pope" wrote in message
...
Hi,

Select the data labels. CTRL+1 to display format dialog.
Select Label Options
Label Position Center

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Thomas M." wrote in message
...
Excel 2007

I have an bar chart that has vertically oriented data labels that are
centered on each bar of the chart. I need to reproduce that for another
chart, but I'm having a hard time figuring out how I got it to work the
first time. I know how to add the series label to the chart and to flip
the labels vertically, but the labels all appear above the bar instead of
being centered within the bar. How do I get the series labels to
automatically center within each bar?

Thanks for any insight that you can provide.

--Tom




  #4   Report Post  
Old May 9th 09, 11:15 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default Data Series Label Positioning

Care to email me directly an example of your file?

andy AT andypope DOT info

Cheers
Andy

Thomas M. wrote:
I don't see a "Label Position" option. I *do* see an option for alignment,
which is where you set the horizontal alignment and text direction, but I
see nothing for vertical alignment. I thought that maybe the number was too
large to fit within the bar, so as a test I dummied up the data to make it a
small number so that there would be plenty of room for the number to fit
inside the bar, but it still displays above the bar.

--Tom

"Andy Pope" wrote in message
...

Hi,

Select the data labels. CTRL+1 to display format dialog.
Select Label Options
Label Position Center

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Thomas M." wrote in message
...

Excel 2007

I have an bar chart that has vertically oriented data labels that are
centered on each bar of the chart. I need to reproduce that for another
chart, but I'm having a hard time figuring out how I got it to work the
first time. I know how to add the series label to the chart and to flip
the labels vertically, but the labels all appear above the bar instead of
being centered within the bar. How do I get the series labels to
automatically center within each bar?

Thanks for any insight that you can provide.

--Tom





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #5   Report Post  
Old May 16th 09, 12:01 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default Data Series Label Positioning

Hi,

The lack of alignment options is due to the use of 3d charts.

And to get the labels centered you need to use the stacked 3d column
rather than clustered 3d.

Cheers
Andy

Thomas M. wrote:
I don't see a "Label Position" option. I *do* see an option for alignment,
which is where you set the horizontal alignment and text direction, but I
see nothing for vertical alignment. I thought that maybe the number was too
large to fit within the bar, so as a test I dummied up the data to make it a
small number so that there would be plenty of room for the number to fit
inside the bar, but it still displays above the bar.

--Tom

"Andy Pope" wrote in message
...

Hi,

Select the data labels. CTRL+1 to display format dialog.
Select Label Options
Label Position Center

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Thomas M." wrote in message
...

Excel 2007

I have an bar chart that has vertically oriented data labels that are
centered on each bar of the chart. I need to reproduce that for another
chart, but I'm having a hard time figuring out how I got it to work the
first time. I know how to add the series label to the chart and to flip
the labels vertically, but the labels all appear above the bar instead of
being centered within the bar. How do I get the series labels to
automatically center within each bar?

Thanks for any insight that you can provide.

--Tom





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


  #6   Report Post  
Old May 18th 09, 11:37 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 68
Default Data Series Label Positioning

That did the trick! Thanks for the help. That was driving me crazy.

--Tom

"Andy Pope" wrote in message
...
Hi,

The lack of alignment options is due to the use of 3d charts.

And to get the labels centered you need to use the stacked 3d column
rather than clustered 3d.

Cheers
Andy

Thomas M. wrote:
I don't see a "Label Position" option. I *do* see an option for
alignment, which is where you set the horizontal alignment and text
direction, but I see nothing for vertical alignment. I thought that
maybe the number was too large to fit within the bar, so as a test I
dummied up the data to make it a small number so that there would be
plenty of room for the number to fit inside the bar, but it still
displays above the bar.

--Tom

"Andy Pope" wrote in message
...

Hi,

Select the data labels. CTRL+1 to display format dialog.
Select Label Options
Label Position Center

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Thomas M." wrote in message
...

Excel 2007

I have an bar chart that has vertically oriented data labels that are
centered on each bar of the chart. I need to reproduce that for another
chart, but I'm having a hard time figuring out how I got it to work the
first time. I know how to add the series label to the chart and to flip
the labels vertically, but the labels all appear above the bar instead
of being centered within the bar. How do I get the series labels to
automatically center within each bar?

Thanks for any insight that you can provide.

--Tom





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to label last point for selected series only EricBB Excel Discussion (Misc queries) 1 January 22nd 09 10:56 AM
Dynamic chart - series label problem pignick Charts and Charting in Excel 2 May 27th 08 07:54 PM
Series 1 Point "0" Data Label Keyrookie Charts and Charting in Excel 2 November 15th 07 01:06 PM
Data Tables Series Label Glyn[_2_] Charts and Charting in Excel 1 October 15th 07 02:30 PM
Data series label in Stacked Chart Connie Charts and Charting in Excel 0 March 13th 07 07:12 AM


All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017