Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Line Width in Line or Scatter Chart | Charts and Charting in Excel | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
Spreadsheet needed for on-line tranactions | Excel Discussion (Misc queries) | |||
combination area and line needed | Charts and Charting in Excel |