+ Reply to Thread
Results 1 to 13 of 13

chart the amount of emails sent each day

Hybrid View

  1. #1
    Registered User
    Join Date
    12-09-2010
    Location
    Houston
    MS-Off Ver
    Excel 2003
    Posts
    7

    Question chart the amount of emails sent each day

    I’ve been reading the posts on this forum for a few days and haven’t found anything that solves my problem.
    I need to chart the amount of emails sent each day. I have a list of the date and time the email was sent. I see it with the Time in the Y-axis and the date on the x-axis. Each email sent would be represented as a dot in the appropriate date/time intersection. I included a picture of what I thought the chart might look like in the attachment if my description is confusing.

    Help!!!
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: chart the amount of emails sent each day

    You need to break the date and time information into 2 columns.

    B1: =
    C1: =EMails
    B2: =INT(A2)
    C2: =MOD(A2,1)

    copy down for data set and plot range B1:C4602 as xy-scatter
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    12-09-2010
    Location
    Houston
    MS-Off Ver
    Excel 2003
    Posts
    7

    Lightbulb Re: chart the amount of emails sent each day

    This sounds great, I'm excited to try it, but I don't understand it!!! lol, can you give me a real example in excel?

    Also, I have a list of times that represent my arrival time, so would it be possible to lay these lines or different color dots over the emails?

    Thank you so much for your reply!!!

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: chart the amount of emails sent each day

    What exactly do you not understand?

    I have given you the formula to put in your example workbook in order to create chartable data.

  5. #5
    Registered User
    Join Date
    12-09-2010
    Location
    Houston
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: chart the amount of emails sent each day

    I am not as advanced and can't get it to work. I've attached my attempts.

    Thanks again,
    Regan

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,740

    Re: chart the amount of emails sent each day

    Is this what you are looking for; I changed the format of your date and time cells. Look at the chart tab
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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