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
Update, this is what my current graph looks like, which is terrible, the circles need to go!
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.
]); //Specifies the options to insert chart in spreadsheet.
const chartObj: any = getComponent(
document.getElementById('Chart1') as HTMLElement,
); // chart object by specifying the chart element it
chartObj.series.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.
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
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,