If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
x axis category name
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 |
#3
|
|||
|
|||
x axis category name
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 |
#4
|
|||
|
|||
x axis category name
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 |
Thread Tools | |
Display Modes | |
|
|