I'm trying to make a stacked bar chart for some transactions made within the year. Ideally, the x-axis is month, the y-axis is amount, and the stacks (layers) are vendor name. But I can't get it formatted correctly. I always select all three columns in my dataset.
This screenshot shows an excerpt of the dataset I'm using:
This shows what comes up when I click "Select Data Source":
... and this is the chart that results:
As you can see, the month values are repeated sometimes, as many transactions were made within the same month.
So how can I get my chart so that the correct data is displayed on the correct axes? What's causing it to display with a strangely formatted y-axis?