Searching \ for '[OT] Excel chart question' in subject line. ()
Make payments with PayPal - it's fast, free and secure! Help us get a faster server
FAQ page: www.piclist.com/techref/index.htm?key=excel+chart+question
Search entire site for: 'Excel chart question'.

Exact match. Not showing close matches.
PICList Thread
'[OT] Excel chart question'
2005\05\18@121524 by PicDude

flavicon
face
Anyone of you know how to create a chart/graph in Excel that uses the data in
a given column for the x-axis data?  Seems like all I can get is the row #
for the x-axis.

Thanks,
-Neil.


2005\05\18@124704 by Alan B. Pearce

face picon face
>Anyone of you know how to create a chart/graph in Excel that uses the
>data in a given column for the x-axis data?  Seems like all I can get
>is the row # for the x-axis.

Right click on the graph, Source data/Series/Xvalues:. Note that if you do
not have smooth data that you are trying to use as the X axis, it may do all
sorts of weird things.

2005\05\18@124833 by Jack Smith

picon face

Anyone of you know how to create a chart/graph in Excel that uses the data
in a given column for the x-axis data?  Seems like all I can get is the row
# for the x-axis.

Thanks,
-Neil.


You must select XY graph type.


Jack

2005\05\18@125504 by Randy Glenn

picon face
Try the X-Y scatter plot. You may need to tweak the data series, and
you should sort the data along one dimension before you run it
(otherwise the plotted line looks crazy - the order it connects points
in is dependent on the listed order of said points)
--
-Randy Glenn
Computer Eng. and Mgt. Year IV, McMaster University
Industry Liason, McMaster IEEE Student Branch

randy.glenn-at-gmail.com - glennrb-at-mcmaster.ca
randy.glenn-at-computer.org - randy_glenn-at-ieee.org
http://www.randyglenn.ca

On 5/18/05, PicDude <spam_OUTpicdude2TakeThisOuTspamnarwani.org> wrote:
> Anyone of you know how to create a chart/graph in Excel that uses the data in
> a given column for the x-axis data?  Seems like all I can get is the row #
> for the x-axis.
>
> Thanks,
> -Neil.
>
> -

2005\05\18@130243 by PicDude

flavicon
face
On Wednesday 18 May 2005 11:47 am, Alan B. Pearce scribbled:
> Right click on the graph, Source data/Series/Xvalues:. Note that if you do
> not have smooth data that you are trying to use as the X axis, it may do
> all sorts of weird things.

It is because I don't have smooth data (x-axis points are not of
equally-spaced intervals), that I want to plot against the x-axis.

Cheers,
-Neil.


2005\05\18@130400 by PicDude

flavicon
face
Aaahhhhh.... this is exactly what I needed.  (I was using a line chart).

Cheers,
-Neil.


On Wednesday 18 May 2005 11:48 am, Jack Smith scribbled:
> You must select XY graph type.
>
>
> Jack


2005\05\19@040712 by Alan B. Pearce

face picon face
>It is because I don't have smooth data (x-axis points are not of
>equally-spaced intervals), that I want to plot against the x-axis.

Ah, then you need the scatter plot like Randy said.

More... (looser matching)
- Last day of these posts
- In 2005 , 2006 only
- Today
- New search...