Illustrations in React Spreadsheet component

[Sum]

1. I want to customize the style aspects like colors, widths, etc., of the columns and gridlines in the chart according to my preferred colors. How can I achieve this?
2. For the 'range' property of ChartModel[], can I concatenate values between rows? In the documentation, I only see an example: range: 'x1:x2', but my desired outcome is range: 'x1:x2, x3:x4' instead of using range: 'x1:x4'.

const chartTest: ChartModel[] = [

{

type: 'StackingColumn',

range: 'A1:E3,A5:E7',

},

];

[Sangeetha Priya Murugan]

Hi Huong,

Query #1: To customize the chart styles:

Currently we don’t have any inbuilt option to change the color and width of chart columns and gridlines. And we have logged this as an improvement. Please find the link below.

https://www.syncfusion.com/feedback/46237/provide-formatting-options-for-charts-in-spreadsheet

Query #2: Discontinuous data range support for chart:

We suspect that you need of discontinuous data range support for chart in our EJ2 Spreadsheet. And currently we don’t have this option and we have already logged this a feature. Please find the link below.

Feedback Link: https://www.syncfusion.com/feedback/33528/discontinuous-data-range-support-for-chart

We regretfully can't start these feature's implementation immediately since we prioritized bug fixes and features that came before them in the queue for forthcoming releases. The time between releases is typically at least three months. Every release cycle, we assess all open features again during the planning phase and decide which ones to deploy based on a number of criteria, such as the product vision, technology viability, and user interest. The feedback will be moved to scheduled status with an estimated delivery period whenever we have more information to provide regarding the development of these improvements. We appreciate your patience until then.

[Sum]

Thank you, so is there any way I can change the input data of the chart from selecting data on the spreadsheet to using JSON data?

[Sangeetha Priya Murugan]

Hi Sum,

Currently, we don’t have support to change data range of the inserted char. However, we have confirmed this as an
improvement
and logged it as a feature. It will be
available in any of our upcoming releases. You can communicate and track the status of the feature using the below link from our feedback portal.

Feedback link for tracking purposes:
https://www.syncfusion.com/feedback/34680/to-provide-support-for-select-data-range-option-in-chart

Unfortunately, we are unable to implement this feature immediately. Since we have some more bug fixes and features that are prior than this feature is in queue scheduled for upcoming releases, we can’t commit this feature at present. We usually have an interval of at least three months between the releases. 

At the planning stage for every release cycle, we review all the open features once again and finalize features for implementation based on specific parameters including product vision, technological feasibility, and customer interest. Once we have anything definite to share about these features implementation, we will move the feedback to scheduled status with the tentative release timeline. We appreciate your patience until then.

[Sum]

How can I take the data range B33:G33 as labels for the columns, and my data range will be from A35:F36 (Classics and Mystery), excluding the Horror data range A34:F34?

Current code snippet

const chart: ChartModel[] = [

{

type: 'StackingColumn',

range: 'A33:F36',

},

];

 <SheetDirective>

          <RowsDirective>

            <RowDirective>

              <CellsDirective>

                <CellDirective

                  index={2}

                  chart={chart}

                ></CellDirective>

              </CellsDirective>

            </RowDirective>

          </RowsDirective>

          <RangesDirective>

            <RangeDirective

              dataSource={chartData}

              startCell="A33"

            ></RangeDirective>

          </RangesDirective>

        </SheetDirective>

expected:

[Sangeetha Priya Murugan]

Hi Sum,

 

As we have stated previously, we don’t have support to select the discontinuous data range while inserting the chart in a spreadsheet. And as well, we don’t have any UI-level options to change the data range for the chart elements. We have taken the data range and legend range from the continuous data range only. And we can’t be able to provide a separate data range and legend range while creating the chart in a spreadsheet.

 

Once the below features are available, your requirements can be met. We appreciate your patience until then.

 

Discontinuous chart and legend Range: https://www.syncfusion.com/feedback/33528/discontinuous-data-range-support-for-chart

 

Select Data Range option: https://www.syncfusion.com/feedback/34680/to-provide-support-for-select-data-range-option-in-chart