Change Trendline on Excel Chart

Sundance_Kid

Board Regular
Joined
Sep 2, 2017
Messages
155
Office Version
  1. 365
Platform
  1. Windows
Hey,

Is there a way to change the trendline in the attached Sleep view, so that it looks a lot sharper & trend is clearer over the 30+ days.

Kind of like in the attached CPU view?

Thanks
 

Attachments

  • Night Sleep.PNG
    Night Sleep.PNG
    32.4 KB · Views: 15
  • Sharp Trendline.PNG
    Sharp Trendline.PNG
    181.8 KB · Views: 15

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
The line in the Sleep view is not a trendline. It is just a plot of data points. It looks like one value for each day.

What do you mean by "sharper"?

Also, the CPU Utilization chart does not show a trendline either. It is also just a plot of data, but much denser.

If you want a trendline, then you have to add a trendline to the chart. You will have to decide how you want to model the trend (i.e., linear, quadratic, logarithmic).

What analysis do you want to do on this data? What are you trying to depict or learn from the chart? That way we can help identify the correct method to do that.

This is what a trendline looks like:
 

Attachments

  • trendlines_img1.png
    trendlines_img1.png
    26.1 KB · Views: 12
Upvote 0

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

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