Home 
Search 
Today's 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




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




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 online tranactions  Excel Discussion (Misc queries)  
combination area and line needed  Charts and Charting in Excel 