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?

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.

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.

Thank you.

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

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.

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!!!

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.

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

Open the attachment - everything will be converted automatically.

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

But it doesn't, because you are now introducing more requirements!

OK - can you please provide a sample workbook that realistically reflects your real data? Covering all requirements, please, not just parts of what you want.

No, you can't, but you can copy the workbook, and then desensitise the copy that you post here. That means provide dummy data in the same layout as your real workbook.

OK - so I see what you have asked for. Please would you copy and paste the description of what you want here into your next post so that all members can see what you are looking for. I am not able to help you with a chart with two rings - sorry. My charting skills are not that good. I hope that Andy Pope will see this - he's a bit of a charting wizard!

For the benefit of others, "this chart" is a donut chart with the percentages shown.

Why? The workbook looks the same as the last one to me. Have you solved the issue? If so, can you show us how?

OK - I will have a look shortly.

You need to reference the correct columns:

=SUMIF($B$6:$B$196,B201,$I$6:$I$196)

I think i need Andy, This time i kinda got it working, but now its also showing the 0:00 zero timers cause of the table, can there be a statement if value is 0:00 or < 0:01 then dont show

Try this:

=IF(SUMIF($B$6:$B$196,B201,$I$6:$I$196)=0,"",SUMIF($B$6:$B$196,B201,$I$6:$I$196))

You need semi-colons, not commas, for your locale:

=ALS(SOM.ALS($B$6:$B$196;B201;$I$6:$I$196)=0;"";SOM.ALS($B$6:$B$196;B201;$I$6:$I$196))

The only way you can stop them showing on the chart is by deselecting them.

Give me a few minutes - I have an idea. I will post when I have checked it.

Try basing the chart on cells J201 onwards. This is a summary of the summary table. Hopefully it will work for you.

I suspect there's an easier way of doing this with pivot charts, but I would be using guesswork!

I still hope that Andy Pope sees this ...

You are great! Thank you so very much, if you ever need IT related help, dont hesitate to ask!

But its still showing all names only this time they overlap each other

Thats cool, some dark magic on it and it works, anyway all the 0:00 are still visable in the chart, they are overlapping the other real data,
Im also trying to move, when i create a new J101, to D101, same as K101 to E101. This to make it a little bit more compact. I believe when i need more rows, i can just insert them and the rows is formula will correct the formulas.

Im so graitfull for this!


EDIT: I Reacreated the chart and it seems to work now.

Glad to have helped, even partly.

Thanks for the offer of IT help - not sure I need any at the moment, though, but thanks.

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