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
|
|||
|
|||
Gridlines & Tick marks
Morning,
Annoying thing about charts in excel - i cant show the tick minor tick marks or gridlines without showing the major ones. The x-values in my chart are specified in the table, 70,75,80% etc. What is weird is it works fine on the y-axis, I have the gridlines and tick marks only opposite the values, not between categories. How can I get the lines and larks only opposite the values/categories shown on the x-axis? Thanks LD |
#2
|
|||
|
|||
Gridlines & Tick marks
You are working with a Line chart?
You can format the x-axis to have category labels align with the tick marks. Just right click the axis and select Format Axis then locate the required option Need more details: Tell us what version of Excel you are using best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "LiAD" wrote in message ... Morning, Annoying thing about charts in excel - i cant show the tick minor tick marks or gridlines without showing the major ones. The x-values in my chart are specified in the table, 70,75,80% etc. What is weird is it works fine on the y-axis, I have the gridlines and tick marks only opposite the values, not between categories. How can I get the lines and larks only opposite the values/categories shown on the x-axis? Thanks LD |
Thread Tools | |
Display Modes | |
|
|