Radar Graph internal lines modification

[antros48]

Hi all,
I created a radar graph using vba and have completed almost all the tasks needed for my excel. The graph is used to display the personal skills along with the evaluation number that is given by a user which is between 1 - 5. I attach my code and also the image of the result. However, as it is shown in the result picture, the internal lines are 10 and not 5. I need to change this to 5 so that it is clearer to the user the evaluation mark on each skill.
I haven't figure out the parameter to use for this modification so any help appreciated.
Thank you.

Please Login or Register  to view this content.

[MrShorty]

Two possibilities:

1) I notice that you are deleting the minor gridlines for the value axis. One possibility is to keep the minor gridlines and set the minor unit to 5 (using the .MinorUnit property).
2) Or set the major unit to 5 using the .MajorUnit property.

Help file for the axis object with links to each property: https://docs.microsoft.com/en-us/off...l.Axis(object)

[antros48]

Thank you very much. That is what i was looking for. Appreciate it!