Mar 10 2023 09:16 AM - edited Mar 10 2023 10:31 AM
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 |
Mar 10 2023 01:25 PM
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.