Using component Column chart and want to add a second serie as a line chart

0
Hi I'm using a standard column chart to show 1) a multiple serie, this works fine, and shows a bar per series-item. 2) now a want to add a second serie and the series items should show up in a line chart (together with the barchart as mentioned under 1).    Adding {"type":"line"} in developer mode to the serie 2) works fine: series 1) is shown in bar and serie 2) as a line. But adding this to the Advanced tab/ Custom series option of series 2) does not work. As a result: series 1) and 2) are shown as bar and the series 2) settings are empty like {}.   Can this be solved so the column charts also shows the line chart, looking at the plotly documentations it looks like this should work. Any ideas?   Thanks already Peter
asked
2 answers
0

Hi Peter,

 

I feel, the issue is that the Advanced --> Custom Series options. It expect a valid JSON object, but the settings may not be applying correctly. Try the following:

  1. Go to the Advanced tab of the chart widget.

  2. Under Custom Series, add the following JSON for your second series - {  "type": "line"}

  3. Ensure that this JSON is correctly assigned only to the second series and not the entire chart.

  4. If it still does not work, try adding this under Custom Layout in the Advanced tab -- {  "barmode": "group"}

This ensures that the bar and line chart render correctly together.

answered
1

The problem is solved, I think it's a bug. The line specified by Srinivas works as long as developer mode  is turned of while publishing the app.

 

So : 

{ 

"type": "line"

}

 

is correct defining it,  in the Custom Series tab of the 2second series, shows a linechart for the 2second serie.

But have in mind: set developer mode off before deploying it, otherwise it is shown as a bar.

 

Kind regards 

Peter

answered