1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help in strip chart making

Discussion in 'Discuss Data Visualizations and Charting' started by Alok Mishra, Sep 15, 2018.

  1. Alok Mishra

    Alok Mishra New Member

    Messages:
    14
    Want to color it automatically with reference I just need to put chainage and offset and it should be hatched automatically. Can Anyone Help me?
    Please use such a forumula so that I can use it on a larger scale with different colors with multiple charts like that. Suppost i have multiple charts like this with different colors.
    Now what will I do?

    Attached Files:

  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,639
    Thomas Kuriakose likes this.
  3. Alok Mishra

    Alok Mishra New Member

    Messages:
    14
    it's a very big thread for a newbie like me sir. Please do this for me also so that I can apply in a larger scale
  4. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,639
    I am traveling for work tomorrow
    I will not have time to attempt this for at least a week

    Go to the last file and look at what it does, where it gets the data from and the format of the data
  5. Alok Mishra

    Alok Mishra New Member

    Messages:
    14
    I will wait for a week sir because when I am opening that file, it's asking for some login information and after that file is not responding.
  6. Alok Mishra

    Alok Mishra New Member

    Messages:
    14
    can you perform it now sir? @Hui
  7. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,639
    @alok

    Three questions

    Will there only ever be 2 rectangles on each chart or can there be multiple rectangles?

    Are Ref K & Y always on Sheet A and C & D on Sheet B ?

    If K, Y, C & D are on the same Sheet, what is the order ?
  8. Alok Mishra

    Alok Mishra New Member

    Messages:
    14
    @Hui
    1- There can be many rectangles.
    2- no, k, y, c, d can be on same sheet. order is d is lowest and then c, then y and k is the upper most layer.
  9. Alok Mishra

    Alok Mishra New Member

    Messages:
    14
    please make it like I can understand easily sir. Note, it's not like in chainage and offset, I am going to give input only 1,2. It can be decimal also sir like 1.2 or 2.9 or in offset, 17.2 like that sir.
  10. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,639
    All ok

    Is there only a Sheet A and Sheet B or can there be Multiple Sheets ?
  11. Alok Mishra

    Alok Mishra New Member

    Messages:
    14
    there can be multiple sheets sir? @Hui
  12. Alok Mishra

    Alok Mishra New Member

    Messages:
    14
  13. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,639
    @alok

    I am sorry I am rather busy at work

    I will get to this when i have time
  14. Alok Mishra

    Alok Mishra New Member

    Messages:
    14
  15. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,639
    @Alok Mishra

    upload_2018-10-25_10-36-29.png

    Please see attached file:

    Simply update the Chainage and Offset table
    Press Execute

    Pressing Reset remove all the shapes and tables except the Chainage and Offset table

    You don't need to press reset before execute, as Execute clears the area anyway

    Considering that there several hours of work involved here,
    You may want to visit my link at: Donate

    Enjoy

    Attached Files:

    Last edited: Oct 25, 2018
    Thomas Kuriakose likes this.

Share This Page