trend lines

  1. C

    Linear Trend Line with data on Secondary Axis

    Hello. I am trying to create a trend line for multiple series of data. Is it possible to have trend lines for only a specific data series within the same chart? For example, in the chart below, I'd like to have a trend line for Student ELA, ELA CA, Student Math, and CA Math but the trend line...
  2. R

    calculate if your sales are up or down with a nice chart

    Hello Everyone, Can you please help me make a trend chart to determine if our sales of units in this time span is trending up or down. Thank you.
  3. T

    Help with plot returning strange values for trendline

    Hi folks, I am trying to do a calibration curve and have strange results from the trendline. It appears to be giving me a trend that beggars belief! Just looking at the X and Y axes, it seems apparent that the relationship given is not likely at all. Can you advise on where I'm going wrong...
  4. M

    Pivot Chart with Slicers, Trendline Problem.

    Hello Excel people! I've been working on a report, showing the total hours provided by each supplier, broken down by the Zone they are based. I've attached an image to show you, this is a Pivot Chart, controlled by slicers including a Linear Trend line Forecast. currently showing all...
  5. S

    lock a trend line and re-plot the outlier without effecting the trend line

    I have a small data set with Fiscal years and Sales. One of the data points is an outlier so in order to get an accurate trend line I have omitted the outlier data point. I have already created a trend line omitting the outlier. What I want to do: 1) Lock the trend line and re-plot the...
  6. D

    Analyzing Attendence Records with Charts and Trend Line Excel 97-2003

    Hi All, I have completed multiple charts and statistical analysis years ago in statistics class and I cannot remember how to do a simple analysis of a multiple year, weekly attendance record. I used the linear chart template and plotted the data that way, but I'd like to take it further and add...
  7. M

    Excel Stock Question

    I am attempting to produce a candlestick chart of a stock and draw on the chart the support and resistance trend lines. I have found a couple of methods through online searches. I want to see if anyone on this board has any suggestions or prior experience with this challenge? Grateful for all...
  8. R

    Formula to find trend line value from slope value...

    Ive seen many posts relating to equations and formulas to find trend line values from a set of data using LINEST, EXP and LN, but I haven't been able to find anything that will help me find a trend line value where the slope value is already known - so hoping someone can help. In a nutshell, I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top