Multiple lineset elements in a MSStackedColumn2DLineDY chart

[Odhran]

Hi,

 

I'm trying to create a multiseries stacked chart with a secondary y axis.

I'm using the MSStackedColumn2DLineDY chart type and the documentation states:

 

There can be multiple <lineset> elements. All the lines created using <lineset> elements are attached to the secondary Y axis of the chart.

 

Could you provide an example of this, as the only way I can get the chart to display more data as a line is by adding it as a new series to the one lineset element.

 

E.g. I want the following to be two different lineset elements, not two series within one lineset

"lineset": [{
            "seriesname": "Cost as % of Revenue",
                "showvalues": "0",
                "linethickness": "4",
                "data": [{
                "value": "57"
            }, {
                "value": "68"
            }, {
                "value": "79"
            }, {
                "value": "73"
            }, {
                "value": "80"
            }]
        }, {
            "seriesname": "Cost as % of Pay",
                "showvalues": "0",
                "linethickness": "4",
                "data": [{
                "value": "34"
            }, {
                "value": "23"
            }, {
                "value": "52"
            }, {
                "value": "32"
            }, {
                "value": "12"
            }]
        }]

A working example of multiple linesets would be greatly appreciated.

 

Many Thanks,

Odhran Hardy

[Swarnam]

Hi,

 

As requested, please find the working example for MSStackedColumn2DLineDY chart type.

 

Hope this helps.

MSStackedColumn2DLineDY (2).zip

[Odhran]

Hi Swarnam,

 

Thanks for the response but this is what I already have working, see my example above.

What I am looking for is to have multiple linesets similar to how you have 2 distinct datasets in the example you supplied.

One for the series relating to services and one for series relating to products
 

E.g. You have the following structure in your example

"dataset": [    
{      "dataset": [...all the series related to products...]
    },
    
{      "dataset": [...all the series related to services...]
    }]

I would like something similar for linesets, is this possible?

 

Many Thanks,

Odhran

[Guest Rishab]

Hi,

 

In JSON data format, to display more than one lineset you need to add it as a new series under the lineset element.

It is not possible to have more than one lineset element in the JSON file.

[Odhran]

Hi Rishab,

 

Many thanks for the feedback, I'll have to work within those contstraints.

The documentation threw me for six but I now get that it was talking explicitly about XML.

 

Many Thanks,

O.

[Guest Rishab]