Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 235
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to align the category axis to plot area awrex Charts and Charting in Excel 6 November 4th 06 12:52 PM
If I do not plot empty cells, how do I change the category axis? Andrew Edmonds Charts and Charting in Excel 0 August 2nd 06 04:41 PM
can I make the vertical axis the category axis in Excel line graph power1 Charts and Charting in Excel 1 March 20th 06 08:45 PM
Adding data on Axis Major Gridlines next to Category Axis Collums jblittlejohn New Users to Excel 0 July 10th 05 12:17 PM
How do I move the Category Axis labels outside of the Plot Area? Brian Shoun Charts and Charting in Excel 1 January 7th 05 05:42 PM


All times are GMT +1. The time now is 09:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"