Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Switching between Workbooks | Excel Discussion (Misc queries) | |||
switching x axis | Charts and Charting in Excel | |||
Switching tabs | Excel Discussion (Misc queries) | |||
switching between modes | Excel Discussion (Misc queries) | |||
Not switching to next worksheet | Setting up and Configuration of Excel |