I want to customize the tick marks in the chart of excel, the size as you like, but it has 4 axes as shown.
Is there any way or addin to customize this for me?
Untitled.png
I want to customize the tick marks in the chart of excel, the size as you like, but it has 4 axes as shown.
Is there any way or addin to customize this for me?
Untitled.png
The easy way to achieve easily distinguished tick marks using standard excel tools would be to use cross marks for main ticks and inner marks for secondary (supplementary) ticks. Of course it will not look exactly as shown on a picture in your post, but may be would be enough for you?
Best Regards,
Kaper
The ticks are short, I want to make it longer to make it beautiful, is there a way to intervene?
Last edited by AliGW; 08-16-2021 at 03:17 AM. Reason: PLEASE don't quote unnecessarily!
Help me! pleaz
If you want custom tickmarks you will need to 'draw' them using dummy series.
You can use xy-scatter with custom x & y error bars.
https://peltiertech.com/axis-with-tick-marks-no-line/
It took me quite a while to apply that, my graphs are logarith. Is there a faster way or custom addin
As you can see, we know nothing about such custom add-in.
If you would follow instruction from the yellow banner near the top I'd probably already in first post present similar method to this mentioned by Andy Pope and described step by step by Jon Peltier
PS. The method works as well with logarithm axes. Looking at the screenshot you presented, you will 8 extra series (main and supplementary, horizontal and vertical, to be plotted on left/bottom or right/top). So may be you shall think of dedicated chart plotting software? (like for instance freeware gnuplot - see some figures here: https://livebook.manning.com/book/gn...n/chapter-8/95 )
It is doable in Excel, and if you plan to produce a number of such graphs may be it is worth time spent.
Can you create an excel addin or macro for me to do in excel. i don't know coder.
I just want to interfere with those ticks to make it a little longer than the default excel
geological, you do not have permission to access this page. This could be due to one of several reasons:
Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
please help me!
What I do is add Control data into Secondary Axis, then show all axis.
The key is the Control data have to represent the min and max point of all data.
If you want someone to develop an add-in for you, then that's a brief, not a request for help. It would therefore be more appropriate to ask the question in Commercial Services, where you can offer payment to your helper for realising the whole project for you. Read about CS here: https://www.excelforum.com/tips-and-...-services.html
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks