x axis alignment w/pos-neg y axis scale

  • Thread starter Thread starter Haldeman
  • Start date Start date
H

Haldeman

Excel defaults the alignment of the months to the center
of the chart ~ I would like to move them to the bottom of
the chart.
 
Haldeman said:
Excel defaults the alignment of the months to the center
of the chart ~ I would like to move them to the bottom of
the chart.
Click to expand...

Select the y-axis. On the menu, select Format | Selected axis | Scale tab.
In the box labeled Category (X) axis crosses at:, enter the minimum value of
the y-axis.

Tip: If your y-axis goes from -10 to +10, you can enter -100000 in the
aforementioned box. Now if your data changes and your minimum value is -25,
your x-axis remains at the bottom.

Dave
dvt at psu dot edu
 
Alternatively, you can keep the axis at zero, but put the labels at the
bottom. Double click the axis or labels to format the axis. On the
bottom-right of the patterns tab, choose Low for the labels.

- Jon
 
Back
Top