Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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/ |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text label in x-axis (scatter chart) | Charts and Charting in Excel | |||
Category axis label problem at column chart | Charts and Charting in Excel | |||
Pivot Chart Data Label Format Question | Excel Discussion (Misc queries) | |||
Text Truncated on Vertical Chart Axis Label | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |