+ Reply to Thread
Page 1 of 3 1 2 3 LastLast
Results 1 to 15 of 39

Chart for counting how much time spend on customer

  1. #1
    Registered User
    Join Date
    05-26-2017
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    41

    Chart for counting how much time spend on customer

    As example:

    2018-07-13_13-25-33.png

    I like to have 2 charts. If possible in one.
    That in colum B (klant) are customer shortnames and in column I there is the time i have spend on that costumer.
    I like to have a circle chart that shows me how much time i have spend on which costumers.

    Something like this:
    https://www.google.nl/url?sa=i&sourc...31568579226074

    Could you please tell me how to do this and if its even possible with the time values in column I?
    Attached Files Attached Files
    Last edited by IIIdefconIII; 07-16-2018 at 04:51 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,142

    Re: I cannot even make a simple chart

    I have no idea what you are asking, sorry!

    Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

    • Use concise, accurate thread titles.
    • Your post title should describe what you want to do, not your anticipated solution.
    • Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
    • Responding to a request to change your thread title by doing so is mandatory.

    To change a title go to your first post, click EDIT then Go Advanced and change your title.

    No help to be offered, please, until the OP complies with this request.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  3. #3
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    20,329

    Re: I cannot even make a simple chart

    Also, Attach a sample sheet. Your picture is very small and non-editable.

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn



  4. #4
    Registered User
    Join Date
    05-26-2017
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    41

    Re: Chart for counting how much time spend on customer

    Changed

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,142

    Re: Chart for counting how much time spend on customer

    Thank you.

  6. #6
    Registered User
    Join Date
    05-26-2017
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    41

    Re: I cannot even make a simple chart

    OK so i got the chart working, BUT, the system think that STX are seperate customers, they should be together by name

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,142

    Re: Chart for counting how much time spend on customer

    You need to use the Klant column as your axis labels and the Totaal column for the actual data.
    Attached Files Attached Files

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,142

    Re: Chart for counting how much time spend on customer

    STX are seperate customers, they should be together by name
    Then you need to create a summary table and use that as the source for your chart.

  9. #9
    Registered User
    Join Date
    05-26-2017
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    41

    Re: Chart for counting how much time spend on customer

    Quote Originally Posted by AliGW View Post
    Then you need to create a summary table and use that as the source for your chart.
    To be honest, i have no idea what youre meaning. I will go play with it more instead of wasting youre time. Thank You much for this!

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,142

    Re: Chart for counting how much time spend on customer

    Who said you were wasting our time? If you don't understand, that's fine - I'll try to explain more clearly. That's what this place is about - I come here to help people!!!

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,142

    Re: Chart for counting how much time spend on customer

    Summary table:

    Excel 2016 (Windows) 32 bit
    B
    C
    18
    STX
    1:55
    19
    GMS
    0:10
    20
    ML
    2:45
    Sheet: Blad1

    Excel 2016 (Windows) 32 bit
    C
    18
    =SUMIF($B$10:$B$16,B18,$I$10:$I$16)
    Sheet: Blad1

    Once you've created this, change the data references in your chart to point to it.

    Have a go - let us know how you get on.

    Cheat sheet attached.
    Attached Files Attached Files
    Last edited by AliGW; 07-13-2018 at 08:19 AM.

  12. #12
    Registered User
    Join Date
    05-26-2017
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    41

    Re: Chart for counting how much time spend on customer

    Thank you for the kind words, i tried to pase the code and it gives me a error, i tried to change the sumif to SOM.ALS cause im using a dutch version, but that one is also not working. Shouldnt the code be in another cell D instead of C? cause in C the time data is there.

    Sry just found the example

    PS Ah i get it now
    Last edited by AliGW; 07-13-2018 at 08:27 AM.

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,142

    Re: Chart for counting how much time spend on customer

    Open the attachment - everything will be converted automatically.

  14. #14
    Registered User
    Join Date
    05-26-2017
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    41

    Re: Chart for counting how much time spend on customer

    Thanks to you!

  15. #15
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,142

    Re: Chart for counting how much time spend on customer

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread
Page 1 of 3 1 2 3 LastLast

Thread Information

Users Browsing this Thread

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

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