For the data objects, try to use the values from the example here.
Try using 'y2' as the value for 'yaxis' for the second series.
Add the following Plotly options in the Advanced tab for Series 1 and Series 2 respectively:
{
"name":"YourSeriesName1",
"type":"bar",
"yaxis":"y",
"offsetgroup":1
}
and;
{
"name":"YourSeriesName2",
"type":"bar",
"yaxis":"y2",
"offsetgroup":2
}
In the Advanced tab of the chart widget, add the following Layout options:
{
"title":"YourChartTitle",
"barmode":"group",
"autosize":true,
"yaxis":{
"title":"YourAxisTitle1"
},
"yaxis2":{
"title":"YourAxisTitle2",
"overlaying":"y",
"side":"right"
},
"showlegend":true,
"legend":{
"orientation":"v",
"y":1.25,
"x":1
}
}
The output will be similar to this:
I have It now working change the Yaxis name to “Y2”
{ "name": "Y-axis 1", "yaxis": "y2", "type": "bar" }
Now I have the next thing, if I change both the series to bar then they are stacked on to of each other.