View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Bar Chart Axis Labels

You can do the opposite. If you right-click on the axis and select format
Axis, then remove tick mark labels from the Patterns tab... then right-click
in the middle fo the chart and select chart options, then pick Category Name
(or whichever other option) for Label contains to show the labels outside of
the bars.

"SeanF74" wrote:

Hi, I am trying to create a bar chart (horizontal bars) where the range of my
data goes from -100% to 100%. Here is the data.

Part 1 -45%
Part 2 -15%
Part 3 -5%
Part 4 25%
Part 5 90%

When I create this part, the labels will be on the left side of the vertical
axis, which crosses at 0%, which I want. However, for those with a negative
percentage, I don't want the label to be inside the bar (it makes it harder
to read) on the left side of the axis. Is there any way to put the axis
labels for the negative numbers (parts 1-3) on the right side of the axis and
the positive numbers (parts 4&5) on the left side of the axis.

Thanks,