Switching 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 |
Switching X and Y axis
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/ch...ly_and_demand/ On Tue, 13 May 2008 09:07:01 -0700, BW wrote: 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 |
Switching X and Y axis
Go into Source Data/ Series... and swap the data in the X values and Y
values fields. -- David Biddulph "BW" wrote in message ... 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 |
Switching X and Y axis
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 "David Biddulph" wrote: Go into Source Data/ Series... and swap the data in the X values and Y values fields. -- David Biddulph "BW" wrote in message ... 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 |
All times are GMT +1. The time now is 05:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com