I'm trying to show how our sales people respond to different lead sources. I want to show the number of leads they got from each source, the number of sales they made, and the average amount per sale. I can do all of this in a straight table quite easily.
Then I thought it might make sense to show a bar chart in addition to the table. But when I switched the type from straight table to bar, all three of my expressions showed as a stacked bar. (which, since the number of leads is less than 100, and the number of sales is less than 30, for any salesperson, while the avg amount is in the $1,000's, the lead and sales numbers get lost).
No problem, I thought - I'll just go to the Style tab, and change the presentation from "stacked" to "grouped". But there was no change in doing so!
And a follow on problem - I want to show the numbers on the right axis, and the $ on the left axis, since the scales are so different. But going to the Axes tab and making any selections seemed to have no effect.
Most interesting of all - when I change it to a line graph, I get almost exactly what I want - 3 lines, with two different scales, but of course a line chart is not the way to display it.
Finally, is there a way to add a label to each axis, showing which values it represents?
The only thing that springs to mind is that you're using two dimension in your bar chart. That will cause stacked bars if you have more than one expression too. A line chart will only show the first dimension and ignore all other dimensions you add.
If this isn't the cause of your issue, please post a sample document that demonstrates the problem you described.
The only thing that springs to mind is that you're using two dimension in your bar chart. That will cause stacked bars if you have more than one expression too. A line chart will only show the first dimension and ignore all other dimensions you add.
If this isn't the cause of your issue, please post a sample document that demonstrates the problem you described.
