ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   minor gridline labels (https://www.excelbanter.com/charts-charting-excel/221125-minor-gridline-labels.html)

NevilleT
minor gridline labels
 
Is it possible to display labels for minor gridlines? I want to try and do
it by using a button to select if they are displayed or not.

ExcelBanter AI
Answer: minor gridline labels
 
Yes, it is possible to display labels for minor gridlines in Excel. Here are the steps to do so:
  1. Select the chart that you want to add minor gridline labels to.
  2. Right-click on one of the minor gridlines and select "Format Minor Gridlines" from the drop-down menu.
  3. In the "Format Minor Gridlines" pane that appears on the right-hand side of the screen, click on the "Line" icon.
  4. Under "Line," check the box next to "Minor Gridline" to display the minor gridlines.
  5. Under "Tick Marks," check the box next to "Inside" to display the tick marks on the inside of the chart.
  6. Under "Labels," check the box next to "Category" to display the category labels for the minor gridlines.
  7. Click "Close" to apply the changes.

To create a button that toggles the display of minor gridline labels, you can use a macro. Here's an example of how to do it:

1. Press Alt + F11 to open the Visual Basic Editor.
2. In the editor, click on "Insert" and select "Module" from the drop-down menu.
3. Paste the following code into the module:

Formula:
Sub ToggleMinorGridlineLabels()
    Dim cht As ChartObject
    Set cht = ActiveSheet.ChartObjects(1)
    If cht.Chart.Axes(xlCategory).HasMinorGridlines Then
        cht.Chart.Axes(xlCategory).HasMinorGridlines = False
        cht.Chart.Axes(xlCategory).TickLabels.NumberFormat = ";;;"
    Else
        cht.Chart.Axes(xlCategory).HasMinorGridlines = True
        cht.Chart.Axes(xlCategory).TickLabels.NumberFormat = "General"
    End If
End Sub 
4. Close the editor and return to the worksheet.
5. Click on the "Developer" tab in the ribbon and select "Insert" from the "Controls" group.
6. Choose a button control and draw it on the worksheet.
7. Right-click on the button and select "Assign Macro" from the drop-down menu.
8. Select the "ToggleMinorGridlineLabels" macro from the list and click "OK."
9. Click on the button to toggle the display of minor gridline labels.

Dave Curtis[_2_]
minor gridline labels
 
Hi Neville,

I do this using a dummy series, linked to a check box. Then I use Rob
Bovey's chart labeller for the dummy series.
Bit difficult to explain, but I have an eaxmple if you like.

Dave

"NevilleT" wrote:

Is it possible to display labels for minor gridlines? I want to try and do
it by using a button to select if they are displayed or not.

NevilleT
minor gridline labels
 
Hi Dave
Sounds interesting. Can I get some more information fron anywhere?


"Dave Curtis" wrote:

Hi Neville,

I do this using a dummy series, linked to a check box. Then I use Rob
Bovey's chart labeller for the dummy series.
Bit difficult to explain, but I have an eaxmple if you like.

Dave

"NevilleT" wrote:

Is it possible to display labels for minor gridlines? I want to try and do
it by using a button to select if they are displayed or not.

Dave Curtis[_2_]
minor gridline labels
 
entHi,
I'll try and explain in more detail, or I' can email you the file.
Youll' need to download Rob Bovey's free chart labeller utility, which is a
great little add-in.
Assuming you want x-axis labels, I made a dummy series, consisiting of two
columns of numbers. The first contains the axis labels corresponding to your
minor tick marks,(in say C1:C20) the second all being zero, (in say D1:D20).
Add these to your chart as an x-y series to get a series along the x axis.
You can hide the points later.
Add a checkbox and link it to a suitable cell. Assume G1. Then, enter
another series in E1:E20 for the labels, by entering +IF($G$1,C1,"") and copy
down.
So checking the checkbox will turn these labels on and off.
Use Rob's chart labeller to label the dummy series and you should find using
the checkbox, you can turn the axis labels on and off.

Would it be easier if I sent you the file?

Dave

"NevilleT" wrote:

Hi Dave
Sounds interesting. Can I get some more information fron anywhere?


"Dave Curtis" wrote:

Hi Neville,

I do this using a dummy series, linked to a check box. Then I use Rob
Bovey's chart labeller for the dummy series.
Bit difficult to explain, but I have an eaxmple if you like.

Dave

"NevilleT" wrote:

Is it possible to display labels for minor gridlines? I want to try and do
it by using a button to select if they are displayed or not.

NevilleT
minor gridline labels
 
Hi Dave. Would be very much appreciated. Can you send it to
Thanks

"Dave Curtis" wrote:

entHi,
I'll try and explain in more detail, or I' can email you the file.
Youll' need to download Rob Bovey's free chart labeller utility, which is a
great little add-in.
Assuming you want x-axis labels, I made a dummy series, consisiting of two
columns of numbers. The first contains the axis labels corresponding to your
minor tick marks,(in say C1:C20) the second all being zero, (in say D1:D20).
Add these to your chart as an x-y series to get a series along the x axis.
You can hide the points later.
Add a checkbox and link it to a suitable cell. Assume G1. Then, enter
another series in E1:E20 for the labels, by entering +IF($G$1,C1,"") and copy
down.
So checking the checkbox will turn these labels on and off.
Use Rob's chart labeller to label the dummy series and you should find using
the checkbox, you can turn the axis labels on and off.

Would it be easier if I sent you the file?

Dave

"NevilleT" wrote:

Hi Dave
Sounds interesting. Can I get some more information fron anywhere?


"Dave Curtis" wrote:

Hi Neville,

I do this using a dummy series, linked to a check box. Then I use Rob
Bovey's chart labeller for the dummy series.
Bit difficult to explain, but I have an eaxmple if you like.

Dave

"NevilleT" wrote:

Is it possible to display labels for minor gridlines? I want to try and do
it by using a button to select if they are displayed or not.

Dave Curtis[_2_]
minor gridline labels
 
Done.
Let us know if you received it and how you get on.

Dave

"NevilleT" wrote:

Hi Dave. Would be very much appreciated. Can you send it to
Thanks

"Dave Curtis" wrote:

entHi,
I'll try and explain in more detail, or I' can email you the file.
Youll' need to download Rob Bovey's free chart labeller utility, which is a
great little add-in.
Assuming you want x-axis labels, I made a dummy series, consisiting of two
columns of numbers. The first contains the axis labels corresponding to your
minor tick marks,(in say C1:C20) the second all being zero, (in say D1:D20).
Add these to your chart as an x-y series to get a series along the x axis.
You can hide the points later.
Add a checkbox and link it to a suitable cell. Assume G1. Then, enter
another series in E1:E20 for the labels, by entering +IF($G$1,C1,"") and copy
down.
So checking the checkbox will turn these labels on and off.
Use Rob's chart labeller to label the dummy series and you should find using
the checkbox, you can turn the axis labels on and off.

Would it be easier if I sent you the file?

Dave

"NevilleT" wrote:

Hi Dave
Sounds interesting. Can I get some more information fron anywhere?


"Dave Curtis" wrote:

Hi Neville,

I do this using a dummy series, linked to a check box. Then I use Rob
Bovey's chart labeller for the dummy series.
Bit difficult to explain, but I have an eaxmple if you like.

Dave

"NevilleT" wrote:

Is it possible to display labels for minor gridlines? I want to try and do
it by using a button to select if they are displayed or not.


All times are GMT +1. The time now is 06:44 AM.

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