Thread: Y-axis tick marks in middle of chart?

I am trying to clean up some charts made my someone else. These are line
charts with 9 data lines. Some of the lines wanted to go above the maximum
Y-axis value. When I increased the value to Automatic, the lines are now
within the chart. But the Y-axis tickmarks, which were at the top of the
chart, are now in the middle of the chart. Actually, they are at the value
they were at before; it's as though I've added chart on top of the tick
marks and the tick marks didn't move. The values are still above the top
edge of the chart where they're supposed to be.

Can someone tell me what I need to change to get the tick marks at the top
edge of the Y-axis? Thank you.

Ed

Select the axis double click on it select paterns and select low (or high)
for the location of the tick marks

"Ed" wrote:

> I am trying to clean up some charts made my someone else. These are line
> charts with 9 data lines. Some of the lines wanted to go above the maximum
> Y-axis value. When I increased the value to Automatic, the lines are now
> within the chart. But the Y-axis tickmarks, which were at the top of the
> chart, are now in the middle of the chart. Actually, they are at the value
> they were at before; it's as though I've added chart on top of the tick
> marks and the tick marks didn't move. The values are still above the top
> edge of the chart where they're supposed to be.
>
> Can someone tell me what I need to change to get the tick marks at the top
> edge of the Y-axis? Thank you.
>
> Ed
>
>
>

My apologies. I guess I was using the wrong words to describe the problem.
It seems to be the Y-axis (Category axis) itself that's in the middle of the
chart (plot area). The tick mark labels are on top of the plot area,
aligned 90 degrees like I want. But the Y-axis with the major and minor
hash marks needs to sit on the top line of the plot area, and I can't get it
there.

Ed

"bj" <bj@discussions.microsoft.com> wrote in message
news:A9C21795-90FD-4A6D-8BED-D8FCB7B1F34F@microsoft.com...
> Select the axis double click on it select paterns and select low (or high)
> for the location of the tick marks
>
> "Ed" wrote:
>
> > I am trying to clean up some charts made my someone else. These are
line
> > charts with 9 data lines. Some of the lines wanted to go above the
maximum
> > Y-axis value. When I increased the value to Automatic, the lines are
now
> > within the chart. But the Y-axis tickmarks, which were at the top of
the
> > chart, are now in the middle of the chart. Actually, they are at the
value
> > they were at before; it's as though I've added chart on top of the tick
> > marks and the tick marks didn't move. The values are still above the
top
> > edge of the chart where they're supposed to be.
> >
> > Can someone tell me what I need to change to get the tick marks at the
top
> > edge of the Y-axis? Thank you.
> >
> > Ed
> >
> >
> >

Aha - I found it! It's on the X-axis formatting that I set where it meets
the Y-axis. Got it now. Thanks for the boost.

Ed

"Ed" <ed_millis@NO_SPAM.yahoo.com> wrote in message
news:eoY$$pWYFHA.160@TK2MSFTNGP15.phx.gbl...
> My apologies. I guess I was using the wrong words to describe the
problem.
> It seems to be the Y-axis (Category axis) itself that's in the middle of
the
> chart (plot area). The tick mark labels are on top of the plot area,
> aligned 90 degrees like I want. But the Y-axis with the major and minor
> hash marks needs to sit on the top line of the plot area, and I can't get
it
> there.
>
> Ed
>
> "bj" <bj@discussions.microsoft.com> wrote in message
> news:A9C21795-90FD-4A6D-8BED-D8FCB7B1F34F@microsoft.com...
> > Select the axis double click on it select paterns and select low (or
high)
> > for the location of the tick marks
> >
> > "Ed" wrote:
> >
> > > I am trying to clean up some charts made my someone else. These are
> line
> > > charts with 9 data lines. Some of the lines wanted to go above the
> maximum
> > > Y-axis value. When I increased the value to Automatic, the lines are
> now
> > > within the chart. But the Y-axis tickmarks, which were at the top of
> the
> > > chart, are now in the middle of the chart. Actually, they are at the
> value
> > > they were at before; it's as though I've added chart on top of the
tick
> > > marks and the tick marks didn't move. The values are still above the
> top
> > > edge of the chart where they're supposed to be.
> > >
> > > Can someone tell me what I need to change to get the tick marks at the
> top
> > > edge of the Y-axis? Thank you.
> > >
> > > Ed
> > >
> > >
> > >
>
>

we may be having some discontinuities as to which is the X axis and which is
th Y axis, so try the other axis if it doesn't work
select the vertical axis double click on it and select scale
one of the lines should read "Catagory X axis crosses at " Set this cell
equal to the max value above.
"Ed" wrote:

> My apologies. I guess I was using the wrong words to describe the problem.
> It seems to be the Y-axis (Category axis) itself that's in the middle of the
> chart (plot area). The tick mark labels are on top of the plot area,
> aligned 90 degrees like I want. But the Y-axis with the major and minor
> hash marks needs to sit on the top line of the plot area, and I can't get it
> there.
>
> Ed
>
> "bj" <bj@discussions.microsoft.com> wrote in message
> news:A9C21795-90FD-4A6D-8BED-D8FCB7B1F34F@microsoft.com...
> > Select the axis double click on it select paterns and select low (or high)
> > for the location of the tick marks
> >
> > "Ed" wrote:
> >
> > > I am trying to clean up some charts made my someone else. These are
> line
> > > charts with 9 data lines. Some of the lines wanted to go above the
> maximum
> > > Y-axis value. When I increased the value to Automatic, the lines are
> now
> > > within the chart. But the Y-axis tickmarks, which were at the top of
> the
> > > chart, are now in the middle of the chart. Actually, they are at the
> value
> > > they were at before; it's as though I've added chart on top of the tick
> > > marks and the tick marks didn't move. The values are still above the
> top
> > > edge of the chart where they're supposed to be.
> > >
> > > Can someone tell me what I need to change to get the tick marks at the
> top
> > > edge of the Y-axis? Thank you.
> > >
> > > Ed
> > >
> > >
> > >
>
>
>

Thanks, bj. It's been a long time since I worked with graphs and charts,
and did indeed have the X and Y mixed up. Thanks for staying with me.

Ed

"bj" <bj@discussions.microsoft.com> wrote in message
news:411D97CA-3C31-467F-8EB0-3284412A1319@microsoft.com...
> we may be having some discontinuities as to which is the X axis and which
is
> th Y axis, so try the other axis if it doesn't work
> select the vertical axis double click on it and select scale
> one of the lines should read "Catagory X axis crosses at " Set this cell
> equal to the max value above.
> "Ed" wrote:
>
> > My apologies. I guess I was using the wrong words to describe the
problem.
> > It seems to be the Y-axis (Category axis) itself that's in the middle of
the
> > chart (plot area). The tick mark labels are on top of the plot area,
> > aligned 90 degrees like I want. But the Y-axis with the major and minor
> > hash marks needs to sit on the top line of the plot area, and I can't
get it
> > there.
> >
> > Ed
> >
> > "bj" <bj@discussions.microsoft.com> wrote in message
> > news:A9C21795-90FD-4A6D-8BED-D8FCB7B1F34F@microsoft.com...
> > > Select the axis double click on it select paterns and select low (or
high)
> > > for the location of the tick marks
> > >
> > > "Ed" wrote:
> > >
> > > > I am trying to clean up some charts made my someone else. These are
> > line
> > > > charts with 9 data lines. Some of the lines wanted to go above the
> > maximum
> > > > Y-axis value. When I increased the value to Automatic, the lines
are
> > now
> > > > within the chart. But the Y-axis tickmarks, which were at the top
of
> > the
> > > > chart, are now in the middle of the chart. Actually, they are at
the
> > value
> > > > they were at before; it's as though I've added chart on top of the
tick
> > > > marks and the tick marks didn't move. The values are still above
the
> > top
> > > > edge of the chart where they're supposed to be.
> > > >
> > > > Can someone tell me what I need to change to get the tick marks at
the
> > top
> > > > edge of the Y-axis? Thank you.
> > > >
> > > > Ed
> > > >
> > > >
> > > >
> >
> >
> >

Glad to be of help

"Ed" wrote:

> Thanks, bj. It's been a long time since I worked with graphs and charts,
> and did indeed have the X and Y mixed up. Thanks for staying with me.
>
> Ed
>
> "bj" <bj@discussions.microsoft.com> wrote in message
> news:411D97CA-3C31-467F-8EB0-3284412A1319@microsoft.com...
> > we may be having some discontinuities as to which is the X axis and which
> is
> > th Y axis, so try the other axis if it doesn't work
> > select the vertical axis double click on it and select scale
> > one of the lines should read "Catagory X axis crosses at " Set this cell
> > equal to the max value above.
> > "Ed" wrote:
> >
> > > My apologies. I guess I was using the wrong words to describe the
> problem.
> > > It seems to be the Y-axis (Category axis) itself that's in the middle of
> the
> > > chart (plot area). The tick mark labels are on top of the plot area,
> > > aligned 90 degrees like I want. But the Y-axis with the major and minor
> > > hash marks needs to sit on the top line of the plot area, and I can't
> get it
> > > there.
> > >
> > > Ed
> > >
> > > "bj" <bj@discussions.microsoft.com> wrote in message
> > > news:A9C21795-90FD-4A6D-8BED-D8FCB7B1F34F@microsoft.com...
> > > > Select the axis double click on it select paterns and select low (or
> high)
> > > > for the location of the tick marks
> > > >
> > > > "Ed" wrote:
> > > >
> > > > > I am trying to clean up some charts made my someone else. These are
> > > line
> > > > > charts with 9 data lines. Some of the lines wanted to go above the
> > > maximum
> > > > > Y-axis value. When I increased the value to Automatic, the lines
> are
> > > now
> > > > > within the chart. But the Y-axis tickmarks, which were at the top
> of
> > > the
> > > > > chart, are now in the middle of the chart. Actually, they are at
> the
> > > value
> > > > > they were at before; it's as though I've added chart on top of the
> tick
> > > > > marks and the tick marks didn't move. The values are still above
> the
> > > top
> > > > > edge of the chart where they're supposed to be.
> > > > >
> > > > > Can someone tell me what I need to change to get the tick marks at
> the
> > > top
> > > > > edge of the Y-axis? Thank you.
> > > > >
> > > > > Ed
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>