Question description:
This user has given permission to use the problem statement for this
blog.
I would like to have a diagram in a new sheet, where the horizontal axis is the days, as they are in column DX. Each day shall show the sum of all unique leads of that day, and I would like to be able to check via a box of checkboxes, which facilities are shown, the facilities are in column BC.
Solved by I. A. in 45 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
13/08/2018 - 03:17
Hi
User
13/08/2018 - 03:17
Hello, I DO have a sheet
User
13/08/2018 - 03:17
Hello there!
Excelchat Expert
13/08/2018 - 03:17
Please share
User
13/08/2018 - 03:18
[Uploaded an Excel file]
User
13/08/2018 - 03:18
There we are. What is your name?
Excelchat Expert
13/08/2018 - 03:18
I can't disclose that... it's against the policy
User
13/08/2018 - 03:19
ok, no problem
Excelchat Expert
13/08/2018 - 03:19
opening the sheet now
User
13/08/2018 - 03:20
Sure.
Excelchat Expert
13/08/2018 - 03:20
I understand on the x axis there would be column DX
Excelchat Expert
13/08/2018 - 03:21
what would be on y axis
User
13/08/2018 - 03:21
You are right, Sorry.
Excelchat Expert
13/08/2018 - 03:21
And BC would be the filtering option through check boxes
User
13/08/2018 - 03:21
Yes.
User
13/08/2018 - 03:22
Actually, I just realized DX should be grouped by day
Excelchat Expert
13/08/2018 - 03:22
Okay
Excelchat Expert
13/08/2018 - 03:22
sure, will do that
Excelchat Expert
13/08/2018 - 03:22
y-axis?
User
13/08/2018 - 03:23
, the time is irrelevant, but the day would be great. So that if I select with the checkboxes say facilities "Seefeldstrasse 69" and "Unspezifisch", it would each day show the sum of all leads for those two facilities.
User
13/08/2018 - 03:23
horizontally should be the dates.
Excelchat Expert
13/08/2018 - 03:23
got it
User
13/08/2018 - 03:23
It has been a long time since school, Sorry: - )
Excelchat Expert
13/08/2018 - 03:23
no problem
Excelchat Expert
13/08/2018 - 03:24
please tell how to get sum of lead
User
13/08/2018 - 03:24
I filtered it by column S, so that every line is one lead, as uniquely identified by their email address in column S.
Excelchat Expert
13/08/2018 - 03:25
So, count of column S would give me the sum of leads?
User
13/08/2018 - 03:26
No. Every line is one lead. Each lead has a date. Ideally, I would like to have the number of leads per day. So to create that sum, per day, that is something I need done.
Excelchat Expert
13/08/2018 - 03:27
got it
Excelchat Expert
13/08/2018 - 03:27
working on .it
User
13/08/2018 - 03:27
cool
User
13/08/2018 - 03:27
thank you
User
13/08/2018 - 03:33
Are you still there and can I help with anything? The clock up there is at 4min, will we be disconnected if it runs out?
Excelchat Expert
13/08/2018 - 03:33
Here it is
[Uploaded an Excel file]
Excelchat Expert
13/08/2018 - 03:33
I attached the solution
Excelchat Expert
13/08/2018 - 03:34
I created an additional sheet
Excelchat Expert
13/08/2018 - 03:34
There's the solution
Excelchat Expert
13/08/2018 - 03:34
For filtering, there are two option provided
Excelchat Expert
13/08/2018 - 03:35
one in the top row and another a slicer
User
13/08/2018 - 03:36
I am happy to pay for an hour if you can finish this with me- I see we are close but either I do not get it or something is not working
Excelchat Expert
13/08/2018 - 03:36
what do you feel is not working?
Excelchat Expert
13/08/2018 - 03:36
I am happy to help
User
13/08/2018 - 03:37
can you open it "here"?
User
13/08/2018 - 03:37
that would be easier
User
13/08/2018 - 03:37
"here" being on the right ->
User
13/08/2018 - 03:37
:-)
User
13/08/2018 - 03:37
ah, now I understand a bit more
Excelchat Expert
13/08/2018 - 03:37
yes... i am not sure if i can
Excelchat Expert
13/08/2018 - 03:38
ut trying
Excelchat Expert
13/08/2018 - 03:38
*but
User
13/08/2018 - 03:39
I understand columns A and B now,
User
13/08/2018 - 03:39
OH, and in the field you made, I can select more than one entry, got it
User
13/08/2018 - 03:39
there is a spike at the end each time- is there a problem if i remove the SUM at the end of column B?
Excelchat Expert
13/08/2018 - 03:40
yes... i will remove and resend it
User
13/08/2018 - 03:40
thank you!
Excelchat Expert
13/08/2018 - 03:41
Here it is
[Uploaded an Excel file]
User
13/08/2018 - 03:42
hm, if I select e.g. only Konradstrasse, the diagram only fills half of the diagram area-
User
13/08/2018 - 03:43
is that a problem with my excel or because only on those days there were leads, e.g. the diagram is set to show 500ish days, and there were only leads on say 250 of them?
Excelchat Expert
13/08/2018 - 03:43
yes, it is because of that only
Excelchat Expert
13/08/2018 - 03:43
do you use windows or mac?
User
13/08/2018 - 03:43
mac
User
13/08/2018 - 03:44
understand- but that is just aesthetics. thank you so much sir or madam! this was REALLY helpful! how do I pay you?
Excelchat Expert
13/08/2018 - 03:45
It will be taken by the portal, once you end the session
Excelchat Expert
13/08/2018 - 03:45
Does this solve the problem?
User
13/08/2018 - 03:45
99% yes, the last 1% I can do myself. Thank you so much!
Excelchat Expert
13/08/2018 - 03:46
you are welcome
Excelchat Expert
13/08/2018 - 03:46
What is the 1% ?
Excelchat Expert
13/08/2018 - 03:46
can try and solve that also
User
13/08/2018 - 03:46
I would like an option to group leads by week and month,
User
13/08/2018 - 03:47
but as it is not a graph that shows each day no matter what, but only the days where there were leads, I guess that is a bit complicated to add.
User
13/08/2018 - 03:47
group leads in the diagram, that is.
Excelchat Expert
13/08/2018 - 03:48
I did not understand the last part
Excelchat Expert
13/08/2018 - 03:48
Do you want me to add month and week to the table?
User
13/08/2018 - 03:49
Yes, that is one part- I would like to be able to look at sums per calendar week and calendar month in the diagram.
User
13/08/2018 - 03:50
It is now by day, if there were a radio button to switch to week and month, that would be the very last thing to make it perfect.
Excelchat Expert
13/08/2018 - 03:52
I can have three different charts
Excelchat Expert
13/08/2018 - 03:52
for day, month and week
Excelchat Expert
13/08/2018 - 03:52
Radio button is not possible
User
13/08/2018 - 03:52
that would also do the trick- if that is possible
User
13/08/2018 - 03:57
are you still there sir/madam?
Excelchat Expert
13/08/2018 - 03:58
yes
User
13/08/2018 - 03:58
Ok
Excelchat Expert
13/08/2018 - 03:58
2 more minutes
User
13/08/2018 - 03:58
thank you so much
Excelchat Expert
13/08/2018 - 04:01
Here it is
[Uploaded an Excel file]
Excelchat Expert
13/08/2018 - 04:01
you are welcome
User
13/08/2018 - 04:01
perfect, thank you so much!
Excelchat Expert
13/08/2018 - 04:02
My pleasure
User
13/08/2018 - 04:02
this is all I needed!
Excelchat Expert
13/08/2018 - 04:02
Please provide feedback at the end of the session
User
13/08/2018 - 04:02
I will, this is a great service, thank you!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.