Bar chart - Label in the bar

[Randhir]

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/43e94f79meb1edd2e/bc/temp/chart+file.xls?BCAcD3EBwMcEneWy


Thanks,

Randhir

 

[Jon Peltier]

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

 

[Randhir]

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]

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