I'm nto charts, please be nice. (Bar graph question)

  • Thread starter Thread starter pgarcia
  • Start date Start date
P

pgarcia

I have a bar graph and when the numbers are populated, they set on top of the
bar. Is there away to have the number huver/float above the bar? I have 6 bar
graphs and I have to click on the amonts and move it up some so your able to
see the number and no, my boss will not let me use the background "opaque".

Thanks
 
Sorry, I should have pointed out that I have Off2k. I have: left, right,
center and justify only.
 
Those are the options for text alignment.

Below those 2 dropdowns, Horizontal and Vertical Text Alignment, is the
Label Position dropdown.

I just checked in XL2K.

Cheers
Andy
 
If it's a bar, he can't float above the bar. Outside end is to the right.
(Yeah, I know, most people say bar when they mean column.)

- Jon
 
Hi Jon,

Your right if it is really a bar chart then above would not be an option.
But Outside end should still be available.

Here are a few suggests for a bar chart.

You could add another series and use that to display the data label
centered. Format the second series to have no fill or border.
With this the displayed bar is slightly off centered.

Or add a duplicate series with 1 extra point at the beginning, which has no
data. Place this series on the secondary axis.
Again format no fill or border. Display data label centered. Now in order to
lift the label above the bar you will need to add the secondary X Axis.
Format the secondary X axis to not have Value (Y) axis crosses between
categories. This will offset the bars enough to make the data labels above
above the bars on the primary axis.

Add XY Scatter series. X values would be half of bar value. Y values would
be 0.5, 1.5 etc
The data label position can be set to above and in order to display the
correct value you would need to link the data labels to cells containing the
true values.

Try Rob Bovey's free add-in for labeling.
http://www.appspro.com/Utilities/ChartLabeler.htm


Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Jon Peltier said:
If it's a bar, he can't float above the bar. Outside end is to the right.
(Yeah, I know, most people say bar when they mean column.)

- Jon
Click to expand...
 
Andy Pope said:
Hi Jon,

Your right if it is really a bar chart then above would not be an option.
But Outside end should still be available.
Click to expand...

That's right. I assumed the OP correctly said bar chart, but looked at
alignment in the incorrect dialog.

- Jon
 
Back
Top