Sign in to follow this  
Odhran

Multiple lineset elements in a MSStackedColumn2DLineDY chart

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this