Simple chart assistance request

Question

I feel a little foolish not resolving this on my own. I want to plot two lines (1 for each stock symbol) over time against a Y axis of share qty. Just can't seem to get it.

DATE	QUANTITY	SYMBOL
3/9/2023	5.561	AGNC
3/1/2023	3.892	PFLT
2/9/2023	5.059	AGNC
2/1/2023	3.809	PFLT
1/11/2023	5.242	AGNC
1/3/2023	3.706	PFLT

hansvogelaar · Answer

Scott2070&nbsp;
The data are not laid out correctly for a chart.
One option is to create a pivot table based on the data, and to create a pivot chart from the pivot table.
Another is to change the layout of the data similar to that of the pivot table.
Both approaches are demonstrated in the attached workbook.

Forum Discussion

Simple chart assistance request

Share