Forum Discussion

Deleted's avatar
Deleted
Nov 03, 2018

How do remove data points on a graph and keep the trendline for the same data points?

 

I want to keep the blue data points, remove the orange data points but keep the orange trendline?

Thank you in advance!

excel
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Nov 05, 2018

    Hi William

     

    Are those DATA Points markers in your chart?

     

    if so you can right click on the line and choose format data series - Marker - None

     

    • Deleted's avatar
      Deleted
      Nov 04, 2018

      I want to keep TRENDLINE but delete orange DATA points , whilst keeping blue data points. 

      I can change trendline to no outline but that would just hide the trendline and not the data points

      • Wyn Hopkins's avatar
        Wyn Hopkins
        MVP
        Nov 05, 2018

        Hi William

         

        Are those DATA Points markers in your chart?

         

        if so you can right click on the line and choose format data series - Marker - None

         

Resources