GRAPH data labels

I have a line graph with positive & negative numbers.

However, the data labels on the x-axis display directly below the 0 line.

Can anyone tell me how I can format the graph so that the labels show below
the bottom (negative value) line.

Many thanks

Hi,

There is an explanation here,
http://www.andypope.info/tips/tip002.htm

Cheers
Andy

gunga wrote:
> I have a line graph with positive & negative numbers.
>
> However, the data labels on the x-axis display directly below the 0 line.
>
> Can anyone tell me how I can format the graph so that the labels show below
> the bottom (negative value) line.
>
> Many thanks

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

One way:

CTRL-Click on the vertical axis and choose Format axis... In the scale
tab, uncheck the "Category (X) axis Crosses at:" and enter the Minimum
value (or more negative) in the textbox.

In article <[email protected]>,
"gunga" <[email protected]> wrote:

> I have a line graph with positive & negative numbers.
>
> However, the data labels on the x-axis display directly below the 0 line.
>
> Can anyone tell me how I can format the graph so that the labels show below
> the bottom (negative value) line.
>
> Many thanks

Double click on the axis or the numbers for the axis.
select paterns and select Tick mark labels "Low"

"gunga" wrote:

> I have a line graph with positive & negative numbers.
>
> However, the data labels on the x-axis display directly below the 0 line.
>
> Can anyone tell me how I can format the graph so that the labels show below
> the bottom (negative value) line.
>
> Many thanks

Brilliant - thanks Andy

"Andy Pope" wrote:

> Hi,
>
> There is an explanation here,
> http://www.andypope.info/tips/tip002.htm
>
> Cheers
> Andy
>
> gunga wrote:
> > I have a line graph with positive & negative numbers.
> >
> > However, the data labels on the x-axis display directly below the 0 line.
> >
> > Can anyone tell me how I can format the graph so that the labels show below
> > the bottom (negative value) line.
> >
> > Many thanks
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>