We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Remove Data Points in Line Chart

Sir, thankyou for your great Spreadsheet control.

A minor thing, but important - How can i remove the data points markers in the Spreadsheets line chart?

For example, in the screen shot below, how do you remove the little hollow round circles that show the data point? I would just like to have a line only without these circ

5 Replies

JA James March 25, 2023 05:46 AM UTC

Update, this is what my current graph looks like, which is terrible, the circles need to go!

SP Sangeetha Priya Murugan Syncfusion Team March 28, 2023 10:37 AM UTC

HI James,

Currently, we don’t have any inbuilt option to disable the markers in our spreadsheet component. However, it can be achieved by setting the visible property to false for the marker in the chart element, as shown below.

Code Block:

  created() {



        type: 'Line',

        theme: 'Material',

        isSeriesInRows: false,

        range: 'E1:F5',

        id: 'Chart1',


    ]); //Specifies the options to insert chart in spreadsheet.



  hideMarker() {

    const chartObj: any = getComponent(

      document.getElementById('Chart1') as HTMLElement,


    ); // chart object by specifying the chart element it

    chartObj.series[0].marker.visible = false; // to disable the marker



For your convenience we have prepared the sample based on our suggestion in a button click event. Please find the link below.

Sample Link: https://stackblitz.com/edit/angular-fuejx8?file=src%2Fapp.component.ts,src%2Fapp.component.html

JA James March 29, 2023 09:37 AM UTC

Thanks for your response  Sangeetha . However, it is not satisfactory.

While it removes the markers, if the chart is moved, or the spreadsheet scrolled, or the tab changed and back again, then the chart just redraws and thus redraws the markers,

The MarkerSettings object must be stored somewhere in the Spreadsheet instance object. There must be a way to interact with it. I can subscribe to actionCompletee() and listen for the 'insertChart' action, from there I can get the chart model. But I get stuck at that point.  The MarkerSettings should be exposed in the API


SP Sangeetha Priya Murugan Syncfusion Team March 31, 2023 07:20 AM UTC

Hi James,

Currently, we don’t have this option in our source level “To insert a line chart with/without marker options” in spreadsheet. However, we have considered this as a feature, and it will be available in our Essential studio volume 2 2023 release. Which is scheduled to be rolled out on end of June 2023. We appreciate your patience until then. You can track the status of this feature using below link from our feedback portal, 

Feedback Portal Link: https://www.syncfusion.com/feedback/42544/provide-support-for-inserting-a-line-chart-with-without-marker-options-in-the

SP Sangeetha Priya Murugan Syncfusion Team June 23, 2023 10:56 AM UTC

Hi James, 


We are glad to announce that our Essential Studio 2023 Volume 2 release v22.1.34 is rolled out and is available for download under the following link. We have included your reported requirement " To insert a line chart with/without marker options” in spreadsheet " in this release. Upgrade to the latest package to avail the fix for the reported issue. 




We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 


Package Link:  https://www.npmjs.com/package/@syncfusion/ej2-angular-spreadsheet 

Live Chat Icon For mobile
Up arrow icon