ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Gridlines & Tick marks (https://www.excelbanter.com/charts-charting-excel/238583-gridlines-tick-marks.html)

LiAD

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



Bernard Liengme[_3_]

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





All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com