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


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



Andy Pope, Microsoft MVP - Excel
"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.