Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 13th 07, 02:36 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 1
Default 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   Report Post  
Old February 13th 07, 03:44 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 837
Default 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   Report Post  
Old April 24th 07, 10:52 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 2
Default 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.



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
Custom Line Width in Line or Scatter Chart Marvin Charts and Charting in Excel 2 February 10th 07 05:44 PM
Getting line on line chart to display after creation from Pivot Table dcsi_jim Charts and Charting in Excel 8 February 6th 07 08:54 PM
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM
Spreadsheet needed for on-line tranactions Ice_Rich Excel Discussion (Misc queries) 0 February 24th 06 09:31 AM
combination area and line needed 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.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017