ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I plot value on x axis and category on y axis? (https://www.excelbanter.com/charts-charting-excel/152881-how-do-i-plot-value-x-axis-category-y-axis.html)

Ben K.

How do I plot value on x axis and category on y axis?
 
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

John Mansfield

How do I plot value on x axis and category on y axis?
 
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).

--
John Mansfield
http://cellmatrix.net





"Ben K." wrote:

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



All times are GMT +1. The time now is 05:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com