+ Reply to Thread
Results 1 to 14 of 14

I want to customize the tick marks

  1. #1
    Registered User
    Join Date
    08-15-2021
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2019
    Posts
    8

    I want to customize the tick marks

    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

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: I want to customize the tick marks

    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

  3. #3
    Registered User
    Join Date
    08-15-2021
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2019
    Posts
    8

    Re: I want to customize the tick marks

    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!

  4. #4
    Registered User
    Join Date
    08-15-2021
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2019
    Posts
    8

    Re: I want to customize the tick marks

    Help me! pleaz

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: I want to customize the tick marks

    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/
    Cheers
    Andy
    www.andypope.info

  6. #6
    Registered User
    Join Date
    08-15-2021
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2019
    Posts
    8

    Re: I want to customize the tick marks

    It took me quite a while to apply that, my graphs are logarith. Is there a faster way or custom addin

  7. #7
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: I want to customize the tick marks

    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.

  8. #8
    Registered User
    Join Date
    08-15-2021
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2019
    Posts
    8

    Re: I want to customize the tick marks

    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

  9. #9
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: I want to customize the tick marks


  10. #10
    Registered User
    Join Date
    08-15-2021
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2019
    Posts
    8

    Re: I want to customize the tick marks

    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.

  11. #11
    Registered User
    Join Date
    08-15-2021
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2019
    Posts
    8

    Re: I want to customize the tick marks

    please help me!

  12. #12
    Registered User
    Join Date
    06-17-2020
    Location
    Bangkok, Thailand
    MS-Off Ver
    365
    Posts
    17

    Re: I want to customize the tick marks

    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.
    Attached Images Attached Images

  13. #13
    Registered User
    Join Date
    08-15-2021
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2019
    Posts
    8

    Re: I want to customize the tick marks

    Quote Originally Posted by Pichai_Tee View Post
    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 do this, it is very long, but it defaults in the machine, just change the length of fishing line that sir

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: I want to customize the tick marks

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] tick marks in middle of graph
    By mufan in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-28-2016, 11:37 AM
  2. Histogram - Indication at Tick Marks
    By zlatan32 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-25-2015, 01:49 PM
  3. Excel 2007 : X axis tick marks will not show up
    By shosan in forum Excel General
    Replies: 1
    Last Post: 04-23-2011, 06:30 AM
  4. inserting tick marks/hash marks
    By psuexv in forum Excel General
    Replies: 6
    Last Post: 09-25-2007, 03:58 PM
  5. Tick marks
    By ofey in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 11-21-2005, 02:35 PM
  6. Placement of tick marks
    By J. McAdams in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-10-2005, 04:05 AM
  7. [SOLVED] Green Tick Marks
    By DNA in forum Excel General
    Replies: 5
    Last Post: 06-13-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1