Charting historical data

Hello matthewb,

welcome to the forum.

Start with a line chart with the first year's data. Then edit the data source. Select the first year data, then hold the Ctrl key and select the next year's data, etc.

The difficulty will be getting some kind of legible label onto the X axis. For this, you may need to create one loooong row with labels in the appropriate cells.

see attached.

cheers