I'm trying to make a scatterplot with the attached data set. The x axis should be Expense Type and the y axis should be the number of days it takes to pay off the expense. The z axis (size of bubble) should be the Spend.
I've tried everything I can think of to debug this chart but for one reason or another it does not work. Any suggestions are really appreciated!!
The best I've been able to get is the x axis is to show the expense categories. The y and z axes are still not correct. My computer is slow to load right now but I used "Expense" and "Days" as dimensions and in the z axis of the scatterplot, I wrote the expression =sum(Spend).
The problem is that the x axis is usually turned into numbers instead of the categories or the y axis just doesn't read at all....
