View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default How to bring data labels in front of objects

In EXCEL 2007 try this:-

- single left hand click the chart to highlight it

- the Chart Tools should become enabled (towards the top right hand side of
the screen)

- single right hand click in one of the columns (for example) the select
Add Data Labels (numbers appear above the top of my columns at this point)

- Chart Tools / Layout / Labels group / Data Labels / More Data Label
Options / in here the first option at the top of the left hand side is Label
Options / select Center on the right hand side (the numbers will move to the
centre of the columns)

- in the Format Data Labels (which is where you should be at the moment)
select Fill on the left hand side (6th option down) / Solid fill / Close

Your labels will now appear in front of the objects on the graph.

I have uploaded an example of the above to:

www.pierrefondes.com

It is the first example on the home page (number 17 at the top of the page)
and has a file reference of:-

Charts_masanao.xlsx

Please click on Yes if my comments have helped.

Thanks!




"masanao.baba" wrote:

How can I bring data labels in front of objects in a graph? Any help
would be appreciated!
.