x axis category name

Hope this solution is simple.

I am using Excel 2000. I have created a graph with numbers
on both the X and Y axis. I have gridlines on both X and Y
axis displayed.

I want to create a standard line graph with the X axis
category name directly under the gridlines. I can only
seem to get them between the X axis gridlines.

I have tried to manipulate the minor gridlines and major
gridlines. If I have only major gridlines selected then
the numbers are between the gridlines. If I select only
minor gridlines, then the numbers are beneath the
gridlines (as I want) but the major gridlines are present
as well. ie I can't make the minor gridlines appear
without the major gridlines with them.

The Y axis is perfect.

Jen

Instead of a line chart, create an XY (Scatter) chart, and display the
major gridlines. The labels should align with the gridlines.

Jen wrote:
Hope this solution is simple.

I am using Excel 2000. I have created a graph with numbers
on both the X and Y axis. I have gridlines on both X and Y
axis displayed.

I want to create a standard line graph with the X axis
category name directly under the gridlines. I can only
seem to get them between the X axis gridlines.

I have tried to manipulate the minor gridlines and major
gridlines. If I have only major gridlines selected then
the numbers are between the gridlines. If I select only
minor gridlines, then the numbers are beneath the
gridlines (as I want) but the major gridlines are present
as well. ie I can't make the minor gridlines appear
without the major gridlines with them.

The Y axis is perfect.

Jen


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Jen wrote:
Hope this solution is simple.

I am using Excel 2000. I have created a graph with numbers on both th=
e =

X and Y axis. I have gridlines on both X and Y axis displayed.

I want to create a standard line graph with the X axis category name =

directly under the gridlines. I can only seem to get them between the=
X =

axis gridlines. I have tried to manipulate the minor gridlines and =

major gridlines. If I have only major gridlines selected then the =

numbers are between the gridlines. If I select only minor gridlines, =

then the numbers are beneath the gridlines (as I want) but the major =

gridlines are present as well. ie I can't make the minor gridlines =

appear without the major gridlines with them.

The Y axis is perfect.

On Sun, 19 Oct 2003 10:41:23 -0400, Debra Dalgleish =

wrote:
Instead of a line chart, create an XY (Scatter) chart, and display the=
=

major gridlines. The labels should align with the gridlines.

I agree with Debra, that's the first plan of attack. As another =

alternative, you might use a dummy series with error bars to simulate =

gridlines in the proper places. See =

http://www.geocities.com/jonpeltier/...s.html#ArbGri=
d =

for a detailed description.

-- =

Dave
dvt at psu dot edu

Jen:
Use the scatter chart with lines and markers.

Jen wrote:
Hope this solution is simple.

I am using Excel 2000. I have created a graph with numbers
on both the X and Y axis. I have gridlines on both X and Y
axis displayed.

I want to create a standard line graph with the X axis
category name directly under the gridlines. I can only
seem to get them between the X axis gridlines.

I have tried to manipulate the minor gridlines and major
gridlines. If I have only major gridlines selected then
the numbers are between the gridlines. If I select only
minor gridlines, then the numbers are beneath the
gridlines (as I want) but the major gridlines are present
as well. ie I can't make the minor gridlines appear
without the major gridlines with them.

The Y axis is perfect.

Jen

--
Gary Klass

Editor, PSRT-L
4600 Politics and Government
Illinois State University
Normal, Illinois 61790
http://LILT.ILSTU.EDU/gmklass
(309) 438-7852
(fax) 438-7638
The Chart of the Week: http://LILT.ILSTU.EDU/gmklass/cow