My chart has positive and negative values. The axis labels appear at the 0 value. How do I move them to the side of the chart.
My chart has positive and negative values. The axis labels appear at the 0 value. How do I move them to the side of the chart.
"gailb14" <[email protected]> wrote in
message news:[email protected]...
>
> My chart has positive and negative values. The axis labels appear at
> the 0 value. How do I move them to the side of the chart.
Format Axis/ Scale/ Value (X or Y) axis crosses at ...
--
David Biddulph
My chart has -10 -5 0 5 10
The labels are at the 0. I must not understand your instructions
Value Y axis crosses at category (1)
Value Y axis crosses between categories (checked)
Value Y axis crosses at maximum category (checked)
This is not working
My chart has -10 -5 0 5 10
The labels are at the 0. I must not understand your instructions
Value Y axis crosses at category (1)
Value Y axis crosses between categories (checked)
Value Y axis crosses at maximum category (checked)
This is not working
Hi,
You will find instructions here,
http://www.andypope.info/tips/tip002.htm
Cheers
Andy
gailb14 wrote:
> My chart has positive and negative values. The axis labels appear at
> the 0 value. How do I move them to the side of the chart.
>
>
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"gailb14" <[email protected]> wrote in
message news:[email protected]...
>
> My chart has -10 -5 0 5 10
> The labels are at the 0. I must not understand your instructions
> Value Y axis crosses at category (1)
> Value Y axis crosses between categories (checked)
> Value Y axis crosses at maximum category (checked)
>
> This is not working
I don't know what sort of chart you're using. You may find that XY scatter
gives you more flexibility.
--
David Biddulph
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks