excelregressiontrendline
Trendline in excel on min max values
I have series of data around 3000 rows. x values are angle, y power. So a cloud is created with max min and average values all over the place (check image attached).
If I use the trend-line option of excel it draws as it should a trend line that matches the median values BUT I want to draw a trend line, on the maximum and another one on the minimum values only. Is there a way to do that?
Thx
Solution
Add the Min and the Max values to the chart as new series. Add a trend line for each of these series.
Next, format the data series for Min and Max to have no fill, no line, no markers, so they become invisible and don't upset your chart display. That leaves only the trendlines visible.
- Excel LET Formula Results in #CALC! Error When Applying a Filter
- Save excel file using savefiledialog class in C#
- Excel, generate a list of names depending on row and column values of another sheet
- Ignore missing columns in pandas read_excel usecols
- When does Excel surround sheet names with single quotes in workbook.xml (or other xml) files?
- getting sheet names from openpyxl
- Counting number of unique values in one column if data in a 2nd column matches anything in a 3rd column
- How to add more than 255 characters in a data validation in xlsxwriter Python
- Open Excel File on a specific worksheet
- Including a value in a range to be summed, only if a date is not today
- XLOOKUP with flexible column for return_array and not unique values in lookup_array
- Get Picture from Worksheet into Excel Userform
- Get names from email column
- How to add the data in the same row index but in different cells in each column
- Consolidating all sheets data into another work book
- Repeat each value a different number of times. Excel
- How to convert a column of age counts into a set useful for statistics?
- VBA Excel Break Points and Stop do not work
- How to find average per day using pivot table?
- Using Excel for VLOOKUP and WildCard Not Working
- Resort from descending to ascending
- Create a scatter in excel using vbscript
- Add cell with comment above table header and matching cell values VBA
- Can you define names for dates in Excel to use them in formulas?
- Override spill cell
- How to create an Excel File with javascript?
- Formula for generating delimited list of incremented numbers
- Return offset cell value based on data validated dropdown list
- Why I could not simply read sheets and merge all the content in a single Variant?
- Extract comments from multiple word docs into Excel