Hi Claire,
Ah, don’t put the numeric attribute on the y-axis. With the categorical attribute on the x-axis, choose Fuse dots into bars from the Configuration menu. Then, from that same menu, you’ll see the option to set the scale using a formula.
I just found the relevant page in the help system. I bet that will help! 😉
Bill