Simple chart assistance request

Copper Contributor

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.

 

DATEQUANTITYSYMBOL
3/9/20235.561AGNC
3/1/20233.892PFLT
2/9/20235.059AGNC
2/1/20233.809PFLT
1/11/20235.242AGNC
1/3/20233.706PFLT
1 Reply

@Scott2070 

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.