+ Reply to Thread
Results 1 to 2 of 2

Graphing multiple concurrent events over time

  1. #1
    Registered User
    Join Date
    08-23-2023
    Location
    London, England
    MS-Off Ver
    365
    Posts
    1

    Graphing multiple concurrent events over time

    I am trying to graph attendance over time for a large number of events. This data is presented by week, so I have attendance per week for each event. The events take place in multiple locations, so I want to be able to see how attendance compares at each venue by graphing the lines on top of each other. So far, I have only been able to display this data cumulatively.

    How would I go about this? Thanks in advance!

    I'm using Office 365 for Mac.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,343

    Re: Graphing multiple concurrent events over time

    It is difficult to give any specific recommendations without some idea of what your spreadsheet data looks like or what charts you have tried.

    As a generic starting place, I would expect to work with your data to arrange it according to the principle Peltier outlines here: https://peltiertech.com/good-chart-data/ With the data properly arranged in the spreadsheet, I would expect it to be fairly easy to create the chart from there.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating concurrent time between multiple users
    By Prairie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2018, 05:58 AM
  2. Need formula to sum all missing items in concurrent events.
    By amdoc in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-08-2013, 04:03 AM
  3. Sum concurrent events with start and end times
    By Ree1209 in forum Excel General
    Replies: 0
    Last Post: 08-12-2011, 03:31 PM
  4. How does Excel/VBA handle concurrent events?
    By batman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2010, 10:09 PM
  5. Graphing days between events
    By California55 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-21-2009, 09:10 PM
  6. [SOLVED] Finding concurrent events from a list with a start and an end time
    By Dave at tch in forum Excel General
    Replies: 3
    Last Post: 01-13-2006, 12:10 PM
  7. Graphing A Time Series of Multiple Stock Prices
    By Alex in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM

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