How to chart a relationship? Excel 2007

  • Thread starter Thread starter Pakku
  • Start date Start date
P

Pakku

Hi all,
I have 2 columns of data. Column 1 contains the number of records
processed on each day. Column 2 is the number of CPU seconds the job
ran to process these records.
I want to create a graph of these values to see what the relationship
is.

This is what I tried.
I flipped the columns around so I could force the CPU seconds to be
the x-axis. I added a header to the 2nd column which I called
"NoOfRecords" but no header on the first one. If I don't do this, I
get like 2 lines, one is completely horizontal.
Next I selected all the data and then Insert 2D Line.

I get a chart which seems somewhat reasonably initially except that
the x-axis looks all funny. Each value I have in the first column is
a value on the x-axis. I really want it to start at 0 and proceed in
increments of 5 seconds.

I think I'm missing something fundamental here, so any help would be
great, thanks!
 
Hi all,
I have 2 columns of data.  Column 1 contains the number of records
processed on each day.  Column 2 is the number of CPU seconds the job
ran to process these records.
I want to create a graph of these values to see what the relationship
is.

This is what I tried.
I flipped the columns around so I could force the CPU seconds to be
the x-axis.  I added a header to the 2nd column which I called
"NoOfRecords" but no header on the first one.  If I don't do this, I
get like 2 lines, one is completely horizontal.
Next I selected all the data and then Insert 2D Line.

I get a chart which seems somewhat reasonably initially except that
the x-axis looks all funny.  Each value I have in the first column is
a value on the x-axis.  I really want it to start at 0 and proceed in
increments of 5 seconds.

I think I'm missing something fundamental here, so any help would be
great, thanks!
Click to expand...

Here is a link to what it looks like
http://img15.imageshack.us/img15/7462/20100215211013.jpg
 
Pakku -

Arrange data with horizontal X axis values in a column on the left and
vertical Y axis values in an adjacent column on the right. Select the data
range of the values in the two columns, e.g., select A2:B101. In Excel 2007
SP2, choose Insert > (Charts) Scatter > (icon with points and no lines). The
XY (Scatter) chart type gives you control over lines/markers and min/max
axis scales. If you need more assistance, post in the
microsoft.public.excel.charting newsgroup.

- Mike
http://www.MikeMiddleton.com



Hi all,
I have 2 columns of data. Column 1 contains the number of records
processed on each day. Column 2 is the number of CPU seconds the job
ran to process these records.
I want to create a graph of these values to see what the relationship
is.

This is what I tried.
I flipped the columns around so I could force the CPU seconds to be
the x-axis. I added a header to the 2nd column which I called
"NoOfRecords" but no header on the first one. If I don't do this, I
get like 2 lines, one is completely horizontal.
Next I selected all the data and then Insert 2D Line.

I get a chart which seems somewhat reasonably initially except that
the x-axis looks all funny. Each value I have in the first column is
a value on the x-axis. I really want it to start at 0 and proceed in
increments of 5 seconds.

I think I'm missing something fundamental here, so any help would be
great, thanks!
 
Pakku  -

Arrange data with horizontal X axis values in a column on the left and
vertical Y axis values in an adjacent column on the right. Select the data
range of the values in the two columns, e.g., select A2:B101. In Excel 2007
SP2, choose Insert > (Charts) Scatter > (icon with points and no lines). The
XY (Scatter) chart type gives you control over lines/markers and min/max
axis scales. If you need more assistance, post in the
microsoft.public.excel.charting newsgroup.

-  Mikehttp://www.MikeMiddleton.com


Hi all,
I have 2 columns of data.  Column 1 contains the number of records
processed on each day.  Column 2 is the number of CPU seconds the job
ran to process these records.
I want to create a graph of these values to see what the relationship
is.

This is what I tried.
I flipped the columns around so I could force the CPU seconds to be
the x-axis.  I added a header to the 2nd column which I called
"NoOfRecords" but no header on the first one.  If I don't do this, I
get like 2 lines, one is completely horizontal.
Next I selected all the data and then Insert 2D Line.

I get a chart which seems somewhat reasonably initially except that
the x-axis looks all funny.  Each value I have in the first column is
a value on the x-axis.  I really want it to start at 0 and proceed in
increments of 5 seconds.

I think I'm missing something fundamental here, so any help would be
great, thanks!
Click to expand...

Thanks Michael. After seeing Chuck's reply I had started to play
around with the scatter type charts and you have given me more solid
direction.
Also thanks for pointing me to that more specialised group- wasn't
aware of it.
 
Back
Top