How do I plot value on x axis and category on y axis?

B

Ben K.

I thought it would be simple but I cannot find how to plot category (in this
case everage price) on y axis and value (quantity sold) on x axis.
Please help!!

Thanks,

Ben
 
J

John Mansfield

Try using an X-Y scatter chart. It will allow you to choose your data sets
for the X values (Quantity sold) and Y values (Average Price).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Finding asymptote equation and how to draw them in excel 0
Scatter chart with categories on x-Axis 2
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Use text descriptors as Y axis units 1
X-Axis Appearing in Plot Area 2
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
Plot a time series on the x-axis and categories on the y-axis 3

Top