**how to create a multiple-color trendline in excel?**

I will just create 2 sets of data (one for actual and one for forecast), make a chart from them and apply separate colors.” But here is a really simple way to get the same effect. Use a semi-transparent box to mask the forecast values.... I have a line chart displaying 2 different lines. Need a trendline for each line, is this possible in Excel 2003? If so, how do I accomplish it? Can I add 2 trendlines to a single chart? I have a line chart displaying 2 different lines. Need a trendline for each line, is this possible in Excel 2003? If so, how do I accomplish it? This thread is locked. You can follow the question or vote

**How to graph two columns together in excel and find the**

I will just create 2 sets of data (one for actual and one for forecast), make a chart from them and apply separate colors.” But here is a really simple way to get the same effect. Use a semi-transparent box to mask the forecast values.... To force it, make another column of arbitrary x-data. Space the numbers evenly and in order, and have the two data sets share this x-data. Then run the trendline formula and solve for the intersection.

**Can I add 2 trendlines to a single chart? Microsoft**

I simply create two sets of data, in the same order as above, but the result is not correct. It seems that excel chooses two different secondary axes for the two sets, which messes things up. When I remove all data from one of the series from the chart, it looks fine again. Is it possible to solve? Christoffer. Kurt says. Sunday, March 16, 2014 at 11:59 am. Looks great, but I messed it up. Is how to make roasted corn 10/06/2014 · Hi, I would like to be able to add a line (a trend line) to a clustered column chart. The attached jpg (picture copied from Excel Charts - Easy Excel Tutorial ) shows the general structure, with the red (poorly) hand drawn lines representing what I want to add to the chart.

**Multiple Trend Lines in Excel YouTube**

When we want to compare two sets of data, we can then create a graph. Select the data you want presented and then click on Insert > XY charts and select the line version. Select the data you want presented and then click on Insert > XY charts and select the line version. how to make a continuous histogram in excel I know how to insert a trendline covering all the data, and extrapolating. But is it possible to insert a trendline covering only a specified period (e.g. the last 3 months). I hoped maybe such an option would be available in excel 2010, but if it is I can't find it. Of course I know this could be done by adjusting the data range of the graph so that it only covers the dates I am interested in.

## How long can it take?

### how to create a multiple-color trendline in excel?

- Excel Trend line (SLOPE() ) and CORREL() yields different
- how to create a multiple-color trendline in excel?
- How to graph two columns together in excel and find the
- How to find intersection point of 2 trend lines? excel

## How To Make 2 Different Tredlines Excel

I want to graph Data Set 1 and Data Set2 in an area graph, so Data Set 1 and 2 will share X-axis point 9:30:29 and 9:32:00 What I am running into is when I graph the second set, it basically overlays the Y data on the same X axis points from Data Set 1.

- I know how to insert a trendline covering all the data, and extrapolating. But is it possible to insert a trendline covering only a specified period (e.g. the last 3 months). I hoped maybe such an option would be available in excel 2010, but if it is I can't find it. Of course I know this could be done by adjusting the data range of the graph so that it only covers the dates I am interested in.
- Excel multiple regression can be performed by adding a trendline, or by using the Excel Data Analysis Toolpak. If you just want to know the equation for the line of best fit , adding a trendline …
- I know how to insert a trendline covering all the data, and extrapolating. But is it possible to insert a trendline covering only a specified period (e.g. the last 3 months). I hoped maybe such an option would be available in excel 2010, but if it is I can't find it. Of course I know this could be done by adjusting the data range of the graph so that it only covers the dates I am interested in.
- I will just create 2 sets of data (one for actual and one for forecast), make a chart from them and apply separate colors.” But here is a really simple way to get the same effect. Use a semi-transparent box to mask the forecast values.