Two variables in chart connected to different axis?

[#1]

Hey guys! This should be simple, I suppose.

I would like to represent 2 variables in the same chart (probably a bar and a line) - they are very connected but the quantities are very different.

One is the amount of tickets in a certain time, the other is the average expenditure per ticket. (E.g: each client spent ~$150 that week, and the total number of tickets was 2500). Since the numbers are very different, they don't look good in the same chart, connected to the same axis. How could I solve this?

Thanks! Cheers

[#2 · Accepted solution]

You can use a secondary axis, similar to in Excel. Put both expressions in to your graph, then on the Axes tab of Chart Properties, select one of the expressions and select Right (Top) under 'Position'. If you upload an example, I can show you what I mean.

[#3]

Here is an example.

[#4]

Yes, it worked