Remember Me?

#1
February 13th 07, 02:36 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Feb 2007 Posts: 1
Beginner help needed with line chart

I'm in a Management Science class going through some probability and
statistics stuff. I'm trying to create a graph that imitates the one
in the book. We're using QM for Windows, but I wanted to something
simple in Excel in order to understand the problems.

I have all the data, but figuring out how to set it up in Excel is
what's killing me.

Two categories:

Receivers with a line drawn from point 0,20 to 40,0
CD players with a line drawn from point 60,0 to 0,20

I want the lines to originate and end on the axis themselves, excel
wants to place them in the middle of the entire graph.

The other thing is I want to enter individual points as above and not
do something like 40,20.

Any help would be appreciated.

#2
February 13th 07, 03:44 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 837
Beginner help needed with line chart

I don't understand your description, but suspect that you need to be using an
"XY (Scatter)" chart instead of a "Line" chart. You can include lines on
either. The distinction is that a "Line" chart assumes that the x axis is
made up of categories (with or without user supplied category labels) instead
of a numeric scale.

Jerry

" wrote:

I'm in a Management Science class going through some probability and
statistics stuff. I'm trying to create a graph that imitates the one
in the book. We're using QM for Windows, but I wanted to something
simple in Excel in order to understand the problems.

I have all the data, but figuring out how to set it up in Excel is
what's killing me.

Two categories:

Receivers with a line drawn from point 0,20 to 40,0
CD players with a line drawn from point 60,0 to 0,20

I want the lines to originate and end on the axis themselves, excel
wants to place them in the middle of the entire graph.

The other thing is I want to enter individual points as above and not
do something like 40,20.

Any help would be appreciated.

#3
April 24th 07, 10:52 AM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 2
Beginner help needed with line chart

dear jerry
please give me a code in c# that plots numeric data in x and y axis
thanks

"Jerry W. Lewis" wrote:

I don't understand your description, but suspect that you need to be using an
"XY (Scatter)" chart instead of a "Line" chart. You can include lines on
either. The distinction is that a "Line" chart assumes that the x axis is
made up of categories (with or without user supplied category labels) instead
of a numeric scale.

Jerry

" wrote:

I'm in a Management Science class going through some probability and
statistics stuff. I'm trying to create a graph that imitates the one
in the book. We're using QM for Windows, but I wanted to something
simple in Excel in order to understand the problems.

I have all the data, but figuring out how to set it up in Excel is
what's killing me.

Two categories:

Receivers with a line drawn from point 0,20 to 40,0
CD players with a line drawn from point 60,0 to 0,20

I want the lines to originate and end on the axis themselves, excel
wants to place them in the middle of the entire graph.

The other thing is I want to enter individual points as above and not
do something like 40,20.

Any help would be appreciated.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Marvin Charts and Charting in Excel 2 February 10th 07 05:44 PM dcsi_jim Charts and Charting in Excel 8 February 6th 07 08:54 PM MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM Ice_Rich Excel Discussion (Misc queries) 0 February 24th 06 09:31 AM BorisS Charts and Charting in Excel 6 September 1st 05 09:54 PM

All times are GMT +1. The time now is 12:32 PM.