I have two sheets in my LibreOffice Calc:
Sheet 1 → Column A → Dates
Sheet 1 → Column B → Numbers
Sheet 2 → Column A → Dates
Sheet 2 → Column B → Events
I basically want to create a chart with an x-axis that functions as a single timeline. The timeline can either be manually defined or generated with dates in ‘Sheet 1’ or ‘Sheet 2’. The y-axis should be created with the ‘Numbers’ in 'Sheet 1. I then want to add certain ‘Events’ from ‘Sheet 2’ to the shared timeline.
Use case: The chart would display how many cars have been sold on certain dates. It should now take the events from the other sheet and insert them to the correct places (percentage of x-axis) on the timeline. It should also be possible to set the duration of an event. In the end, it could show the reader when certain marketing measures happened, for how long and how they affected the number of sold cars.
Is this possible with LibreOffice without too many ‘workarounds’ or do I have to use another software for my purpose? I’m not familiar with the complexity of my requirements and whether I might have to use a special software for that.