Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default x-y plot in Excel 2007 questions

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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default x-y plot in Excel 2007 questions

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Questions Harimau Excel Discussion (Misc queries) 3 April 14th 08 01:53 AM
Excel 2007 questions Otto Moehrbach Excel Discussion (Misc queries) 1 October 28th 07 01:52 AM
Shortcut key questions for Excel 2007 Craig Excel Discussion (Misc queries) 0 August 20th 07 10:52 PM
excel 2007 questions please Kim K Excel Discussion (Misc queries) 1 July 13th 07 03:34 AM
Some questions about Excel 2007 Charts fujing1003 Charts and Charting in Excel 3 April 10th 07 03:40 PM


All times are GMT +1. The time now is 11:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"