You need all years the event was happening in source table!
An example how i'd do this is attached.
Events are defined in table tEvents on Events sheet. The column EventVal is used to determine the position of event in graph, and must be an unique value for every event!
On sheet SetUp you can determine the start year for table tEY on sheet EventYears. This table will be the source for your graph.
You create a graph based on table tEY on sheet EventYears. Event labels for graph you get from named range nEvents at top of same sheet.
|