Forum Discussion
Scott2070
Mar 10, 2023Copper Contributor
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 S...
HansVogelaar
Mar 10, 2023MVP
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.