Forum Discussion
Simple chart assistance request
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 |
1 Reply
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.
