dshrenik
asked on
Linear graph in Excel
I want to create a linear graph in Excel 2010 using the data in the image attached.
The problem is when I select the rows and columns and then try to create a graph, it starts plotting from n=1.
Please let me know how I can start plotting from 0.
If possible ,please give me the step by step procedure.
Thanks!
Graph.png
The problem is when I select the rows and columns and then try to create a graph, it starts plotting from n=1.
Please let me know how I can start plotting from 0.
If possible ,please give me the step by step procedure.
Thanks!
Graph.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the quick reply.
I actually dont want any category labels. Can I just show show it for a uniform distribution between 0 and 200? I want the default numbering to start from 0.
The X-axis must have only "0", "1", "3", and "200" marked.
Thanks!
I actually dont want any category labels. Can I just show show it for a uniform distribution between 0 and 200? I want the default numbering to start from 0.
The X-axis must have only "0", "1", "3", and "200" marked.
Thanks!
ASKER
Please let me know if it possible to have the data points on X axis (0 to 200) uniformly distributes)
Thanks!
Thanks!
If you want to fix the existing chart, right click the chart and select "Select Data".
Delete the "n" series.
Click the Edit button in the right hand pane for Horizontal (Category) labels.
Select the four cells from one cell to the right of the "n" cell to the end. (Sorry, from your screenshot it is not apparent what the cell addresses are. If "n" is in A1, select B1 to E1. Adjust to your setting)
Click OK on all dialog boxes.
cheers, teylyn
Delete the "n" series.
Click the Edit button in the right hand pane for Horizontal (Category) labels.
Select the four cells from one cell to the right of the "n" cell to the end. (Sorry, from your screenshot it is not apparent what the cell addresses are. If "n" is in A1, select B1 to E1. Adjust to your setting)
Click OK on all dialog boxes.
cheers, teylyn
Yes, you can do that with an XY chart instead of a line chart.
Right click the chart, select "Change Chart Type" and select the XY (Scatter) chart type with the lines and the markers.
See attached.
cheers, teylyn
Book3.xlsx
Right click the chart, select "Change Chart Type" and select the XY (Scatter) chart type with the lines and the markers.
See attached.
cheers, teylyn
Book3.xlsx
ASKER
Thank you!
the X axis shows the category labels. Since your data does not include any categories for the four data points for each line, Excel defaults to numbering them from 1 to 4.
What would you like to see on the X axis instead? Insert a row above your data table, enter your categories in that row, then select the data including the category row and build a new line chart.
See the result of that attached.
cheers, teylyn
Book3.xlsx