Creating a Cumulative Ticket Sales Chart for Annual Festivals with Varying Event Dates

0

I need assistance in analyzing ticket sales data for a festival that occurs annually with varying event dates. The festival generally takes place in June, but the specific dates differ each year, and there was one instance in September. The dataset spans 5 years, and ticket sales commenced at different times for each festival.

I want to generate a chart that compares cumulative ticket sales across all five festivals over time, with the timeline working backward from each event date. Ideally, I'd like to have a separate line on the chart for each festival, illustrating the cumulative ticket sales leading up to its respective event date (similar to the sample chart attached).

Is it possible to create such a chart, possibly using parameters for the event dates? If so, could you provide guidance on how to achieve this?

Thank you for your help!

Sample Chart

asked 3 months ago56 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions