Help creating visual representation of data, please

[Dilbertian]

I have spreadsheet data that I want to represent visually. It's rolling data and I want to be able to present a snapshot of it at any point. Preferably using Excel, as that's what I have.

Can anyone suggest how I can achieve this?

I have 5 columns of data. Three (date, blue and pink) have a single item in each row, ie there is one blue and one pink for every date. Two (green and text) may be empty or may have one or more items for every date item.

Everything needs to be plotted against date. Blue and pink are continuous (hence plotted on a line graph) but it is important to differentiate between them (hence different colours). Green is discrete time values. I'm not sure how or even whether to include the text items.

I've sketched examples of the graph I'm trying to create. They are identical except for the position of the X axis.

In Excel there is an Insert Chart button if you select your data and press Insert Chart it will give you options and you can try different graphing choices.

It doesn't allow for charting two sets of data in one line while still differentiation between them. Unless I there is more functionality that I don't know about. (A distinct possibility!)

Can anyone help me? Please?

I don't know if this group could help OP.
www.reddit.com/r/excel/