View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default 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