Charting Mac Excel 2008

Discussion in 'Mac Apps and Mac App Store' started by sharingsunshine, Aug 26, 2013.

  1. sharingsunshine macrumors newbie

    Joined:
    Aug 26, 2013
    #1
    I have 7 days of the week each with different data. I want to chart each day of the week separately in a line graph. This will be showing about 1 month of data at a time

    Here is what the data looks like.

    Day of Week Unique Visits
    Monday 555
    Tuesday 115
    Wednesday 99
    Thursday 92
    Friday 120
    Saturday 103
    Sunday 92
    Monday 105
    Tuesday 113
    Wednesday 128
    Thursday 101
    Friday 110
    Saturday 555
    Sunday 539
    Monday 695
    Tuesday 671
    Wednesday 657
    Thursday 582
    Friday 570
    Saturday 538
    Sunday 572
    Monday 648
    Tuesday 658
    Wednesday 622
    Thursday 630
    Friday 711
    Saturday 523
    Sunday 516
    Monday 623
    Tuesday 604
    Wednesday 638
    Thursday 586
    Friday 374
    Saturday 478
    Sunday 497
    Monday 547
    Tuesday 586
    Wednesday 619
    Thursday 579
    Friday 517
    Saturday 487
    Sunday 462
    Monday 606

    When I try to do a months worth of data Excel just bunches it up so it isn't legible and instead of Days of the week I just get in the legend series 1 thru 30 all with different colors or shapes. I need some way to spread it out so there is more gaps between the lines.

    Please give me some help on how to do this?

    Thanks,

    Randal
     
  2. MisterMe macrumors G4

    MisterMe

    Joined:
    Jul 17, 2002
    Location:
    USA
    #2
    Excel is a powerful application, but I don't think it reads minds. You have given it ambiguous text data. Instead of the days of the week, you should give the dates of the visits.
     
  3. sharingsunshine thread starter macrumors newbie

    Joined:
    Aug 26, 2013
    #3
    I changed it to the dates as you suggested and the graphs are more legible. The only problem is I need to see the trends based on the days of the week. Is there a way to do that since I now have the actual dates being used?
     
  4. RCAFBrat macrumors 6502

    Joined:
    Jul 10, 2013
    Location:
    Montreal, QC
    #4
    I suggest putting the seven days of the week in column A and then have a different column for each week (column B will be week 1, column C will be week 2, etc). You should also have a row on top with column headings for use in the legend.

    You can then do charts where:

    - each week is a different color bar and they are grouped by day; or

    - you can have a single bar for each day of the week with the value (eg sales) for each week a different color but stacked one on top of the other.

    Hope this is helpful.

    Good luck!
     
  5. sharingsunshine thread starter macrumors newbie

    Joined:
    Aug 26, 2013
    #5
    That certainly works so thanks for the help. Now I just need a way to automate the process. I'll probably try Applescript with it.
     

Share This Page