trendlines

hi all. In my Excel at home I have the ability to add trendlines by either right clicking or Add chart elements. I've already tried to add the Tool Pak. Before Trendlines was grayed out in the Add Chart Elements, but didn't show up in the right click. Now it shows up in both, but is still grayed...

Hi all, I have done Analysis in Abaqus for Body and Mattress contact. I have imported my data into Excel sheet, I just want to see the Force vs Displacement curve. I gave Load from 1-500 N so that I get displacement --0.000,.............108 mm,,, I made a non linear Graph for my datas. I...

Hello, I have two data series that are plotting on a date range (the x axis). I've added trendlines to each data set, and at some point in the future these two trendlines cross. I'm interested in being able to determine the date when these two trendlines cross. In the attached file you can...

I have a set of outputs each month that I have plotted into a graph to show the output, the upper and lower capability, and the average expected output per month. I want to create an automated spreadsheet which can adjust the upper and lower levels and the average per month based on 2 months of...

Hi all, I got my problem to fit into a screenshot that shows 2 examples of a logarithmic curve working in Excel charts (upper and lower left) and the third that has driven me to complete madness (upper right). The description of the issue is explained in the picture below. Thanks in advance...

I am trying to create a trendline for multiple series. Is there a way to "create trendline for all series"? I have also tried to use the linest function to get the trendlines but it does not work because I have gaps in my data. Below is an example of my data which I would like to create a...

I have created a chart in excel in which I have created a logarithmic trendline. I am wanting to find out what the Y values of the trendline are. In other words, I have my current Y values that generated the trendline, but I want to know what the Y values of the actual trendline are. If I was...

Hi All, With reference to the image below..... -- removed inline image --- I would like to set a "flag" cell that says "out of limits" if 'Plot Point A' is outside the "In Limits (Green) Area" of the chart which is enclosed by the six trend lines connecting the corner plot points together...