2007 move axis label & add zero line

T

Tankman

Excel 07 - Have several bar charts with negative values. Can I move the axis
label independently of the default relationship to the least value or the
chart floor? And how do I add only the horizontal zero line for reference in
a bar chart with negative and positive values stacked?
 
T

Tushar Mehta

Right click the axis, select Format Axis... In the dialog box, set the Label
position to 'Low' (the default is 'Next to Axis').

The x axis by default is at y=0. So, you should be all set for that. If
you have additional horizontal lines, they are gridlines. To remove them,
click on any so that all show up as selected. Press the 'Delete' key.
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sideways stacked bar charts with line series on the same axis 0
Stacked bar category labels over to the left side 2
align zero markers on combination chart? 2
Stacked Color Charts 1
Changing the data label position below the chart axis. 2
Positioning x axis at bottom of chart with negative values 5
Data labels along below x axis when y axis has negative values 1
Secondary Y axis 2

Top