Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Controlling which data appears on which axis
Hi I need help! I am doing an assignment and I need the data that I have produced to appear on a particular axis. Here is my data: 0 1600 1 1400 2 1200 3 1000 4 800 5 600 6 400 7 200 8 0 After I select it and click the chart wizard button, the 0, 1, 2, 3 etc. data appears on the X axis, but I want it to appear on the Y axis. How am I able to do this?! -- mwr7483 ------------------------------------------------------------------------ mwr7483's Profile: http://www.excelforum.com/member.php...o&userid=37379 View this thread: http://www.excelforum.com/showthread...hreadid=570653 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Controlling which data appears on which axis
Standard practice is to start with the X values in the left hand column, and
Y values to the right. This is also the easiest approach. If you're unwilling/unable to rearrange the data, start the chart wizard, in step 2 click on the Series tab. This dialog holds the key: you can define which ranges are X and Y values on a series-by-series basis. If the charts already exist and you don't want to spend the time to rebuild them, you could try this: http://peltiertech.com/Excel/Zips/SwitchXYAxes.zip - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "mwr7483" wrote in message ... Hi I need help! I am doing an assignment and I need the data that I have produced to appear on a particular axis. Here is my data: 0 1600 1 1400 2 1200 3 1000 4 800 5 600 6 400 7 200 8 0 After I select it and click the chart wizard button, the 0, 1, 2, 3 etc. data appears on the X axis, but I want it to appear on the Y axis. How am I able to do this?! -- mwr7483 ------------------------------------------------------------------------ mwr7483's Profile: http://www.excelforum.com/member.php...o&userid=37379 View this thread: http://www.excelforum.com/showthread...hreadid=570653 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Rotate excel data axis, not in chart format | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
space between y axis and data points.. | Charts and Charting in Excel |