Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I am trying to make an x-y plot and the axis that excel uses are not what I
want. I am comparing wages to 3 different outputs. I want wages on the y-axis and output on the x-axis, but excel does the opposite. I went to "select data" and did "switch row/column" and did not get the results that I am wanting. So my question is, how do I tell excel what I want on the x-axis and y-axis? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
The simplest way: You put the x-values in one column and the y-values in a
column to the right. You make the chart from this data Or with the 'wrong' chart.Right click and use Data Source; In the dialog change the entries for the x and y values. Changing row/col is saying the data is in row not columns best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "jacketsfan33" wrote in message ... I am trying to make an x-y plot and the axis that excel uses are not what I want. I am comparing wages to 3 different outputs. I want wages on the y-axis and output on the x-axis, but excel does the opposite. I went to "select data" and did "switch row/column" and did not get the results that I am wanting. So my question is, how do I tell excel what I want on the x-axis and y-axis? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Questions | Excel Discussion (Misc queries) | |||
Excel 2007 questions | Excel Discussion (Misc queries) | |||
Shortcut key questions for Excel 2007 | Excel Discussion (Misc queries) | |||
excel 2007 questions please | Excel Discussion (Misc queries) | |||
Some questions about Excel 2007 Charts | Charts and Charting in Excel |