 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / May 2008Switching X and Y axis
How do I switch the data on the X and Y axis? For instance, I am trying to do a supply and demand chart, and I want Price to be on the Y axis. No matter how I plot the data, Excel always defaults to the supply and demand figures on the Y axis. thank you! BW Duplicate the price column after the quantity column and plot the quantity and the new price columns. See Drawing Supply and Demand curves in Excel http://www.tushar-mehta.com/excel/charts/supply_and_demand/ >How do I switch the data on the X and Y axis? For instance, I am trying to >do a supply and demand chart, and I want Price to be on the Y axis. No [quoted text clipped - 4 lines] > >BW Go into Source Data/ Series... and swap the data in the X values and Y values fields. -- David Biddulph > How do I switch the data on the X and Y axis? For instance, I am trying > to [quoted text clipped - 5 lines] > > BW David, thank you for your response. I should have specified that I was using a line graph. I realized that I should be using a Scatter Plot and have since had succes doing exactly as you noted. Thank you! BW > Go into Source Data/ Series... and swap the data in the X values and Y > values fields. [quoted text clipped - 10 lines] > > > > BW
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.