+ Reply to Thread
Results 1 to 3 of 3

Excel noob needs help with his design

  1. #1
    Registered User
    Join Date
    05-24-2019
    Location
    netherlands
    MS-Off Ver
    2007
    Posts
    1

    Question Excel noob needs help with his design

    Hello. Could someone please help me with my problem (i don't understand excel very well

    I am trying to make a graph/image/whatever, but can't figure out how to make this specific design. What is want to make is as follows:

    i have 10 people who started at day 0. Each of them had to reach three goals in consecutive order and i have recorded on which day they all achieved those goals. It basically looks like below, for example.
    It shows day 0 and how many days from day 0, they reached the goals (in order).

    person 1: 0, 10, 15, 20
    person 2: 0, 20, 30, 40
    person 3: 0, 7, 14, 25

    Now i want a graph that has time (in days) on the x-axis and each individual person on the y-axis represented by a horizontal line. Each individual horizontal line should have 3 highlights indicating the days on which they reached their goals.
    I hope you understand what i mean and can help with creating this.

    thanks a lot

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Excel noob needs help with his design

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Excel noob needs help with his design

    May be stacked bar chart.

    See attached.

    Or perhaps, Gantt chart may be what you are after.
    Attached Files Attached Files
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ 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. Hello Excel noob here
    By Kohor in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-24-2014, 11:11 PM
  2. Excel Noob problem
    By e1234low in forum Excel General
    Replies: 4
    Last Post: 01-19-2014, 03:15 PM
  3. Excel Noob
    By darkangelx387 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-04-2013, 05:52 AM
  4. Joining Text Cells
    By loppydog in forum Excel General
    Replies: 1
    Last Post: 12-04-2012, 01:16 PM
  5. Hi from a Excel noob
    By cargando in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-14-2012, 07:15 PM
  6. Excel Noob
    By vikhound in forum Excel General
    Replies: 1
    Last Post: 08-24-2009, 02:15 PM
  7. [SOLVED] Hyperlinks Inserted in Design Mode inactive once Exited Design Mod
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2005, 01:06 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