Remove Data Points in Line Chart

[James]

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

[James]

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

[Sangeetha Priya Murugan]

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() {

    this.spreadsheetObj.insertChart([

      {

        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'

    ); // 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

[James]

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

James

[Sangeetha Priya Murugan]

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

[Sangeetha Priya Murugan]

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. 

 

https://www.syncfusion.com/forums/183035/essential-studio-2023-volume-2-main-release-v22-1-34-is-available-for-download 

 

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