Bar chart - Label in the bar
 

Hi - I am trying to get the country name (Y axis) in the bar instead of on
the axis so it takes up less space. any ideas on how I can do this?

Here is a file
http://us.f13.yahoofs.com/bc/43e94f7...AcD3EBwMcEneWy


Thanks,

Randhir

Bar chart - Label in the bar
 

Double click the bars, and on the Data Labels tab, choose one of the options
shown, presumably Show Categories. Then double click on the labels to adjust
their positions, and on the axis to hide the existing category labels
(Patterns tab: None for tick labels).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Randhir" wrote in message
...
Hi - I am trying to get the country name (Y axis) in the bar instead of on
the axis so it takes up less space. any ideas on how I can do this?

Here is a file
http://us.f13.yahoofs.com/bc/43e94f7...AcD3EBwMcEneWy


Thanks,

Randhir

Bar chart - Label in the bar
 

Hey Jon - I did that, and it works well - kinda. The issue I am now trying to
solve is to have the country name in the left corner and the percentage in
the right corner. I tried to move the box, but they seemed to be joined at
the hip! I tried to 'justify' the alignment and other tweaks, but just could
not get it there yet.

http://www.flickr.com/photos/randhir/212684058/

Bar chart - Label in the bar
 

Hi,

As the picture would indicate you are not displaying the value axis you
could just set it's minimum value to a negative value. Say -.2
The vertical category axis would still cross and the zero value.

Aheers
Andy

Randhir wrote:
Hey Jon - I did that, and it works well - kinda. The issue I am now trying to
solve is to have the country name in the left corner and the percentage in
the right corner. I tried to move the box, but they seemed to be joined at
the hip! I tried to 'justify' the alignment and other tweaks, but just could
not get it there yet.

http://www.flickr.com/photos/randhir/212684058/



--

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