To create an Excel chart with multiple lines, create a new chart with multiple plot lines or add plot lines to an existing chart. Create a New Chart With Multiple Lines When you create a new chart in Excel, you must specify the data to be plotted (for more information please see How to Make a Line Graph in Microsoft Excel ). How to Add a Vertical Line in a Chart in Excel Sometimes while presenting data with an Excel chart we need to highlight a specific point to get user’s attention there. And the best way for this is to add a vertical line to a chart.

• Add Horizontal Line To Excel Chart 2010
• How To Add Line To Scatter Plot
• How To Add Leader Lines In Scatter Plot Excel

I have two groups of data. One group has three points: (0.5, 2), (1.5, 3) and (4, 5). The other group has two points: (0, 1) and (3, 4). I want to plot the first group as a scatter plot, and the second as a straight line segment, and a quadratic function $y=x^2$ over $x in [0,5]$ in the same plot. I wonder how to do that in Excel?

I know how to plot the first group as a scatter plot. First create a column with data: 0.5, 1.5 and 4, and another column with data: 2, 3 and 5; then select the two columns, and click 'Insert -> Scatter' and choose a type of scatter plot.

But I don't how to plot the other two, i.e. a line segment and a quadratic function.

I also don't know how to plot them in the same graph as the scatter plot. If I plot the second group of data, it will be plotted in another graph. How can I plot it in the same plot as the first group of data?

Skyrim jon snow mod. Excel 2007.

Add Horizontal Line To Excel Chart 2010

studiohack♦

How To Add Line To Scatter Plot

migrated from stackoverflow.comSep 28 '11 at 5:34

This question came from our site for professional and enthusiast programmers.

How To Add Leader Lines In Scatter Plot Excel

2 Answers

For the line segment, you just choose to plot as a scatter plot, but use a line to connect the points.

For the quadratic, you will need to compute a number of points on your curve and then plot them also as a scatter plot, and again, use a line to connect the points from your minimum X value up to your maximum X value.

Update (for Excel 2007 .. probably similar for other versions, but this is what I have in front of me):

To add an additional plot to your chart:

1. Right click on an empty place in your chart and select 'Select Data'
2. Select 'Add' from the Series list
3. Optionally, name the series in the Series name textbox .. it will be given a default name if you don't provide one.
4. Click on the Series X data textbox, and select the X values for your scatter plot
5. Click on the Series Y data textbox, and select the Y values corresponding to the X values you just selected
6. Press 'OK'

I'd have four columns: X, your scatter, your linear, and your quadratic. Have X go from 0 to 4 in steps of 0.01 (use fill .. series). Fill the three scatter points in the appropriate place. Then fill the other two columns with your function values for the line segment and the parabola. Adjust the size of the points in the last two so they're a little thinner and look like lines rather than points.

JW.JW.

Not the answer you're looking for? Browse other questions tagged microsoft-excelmicrosoft-excel-2007 or ask your own question.