You should be able to achieve something similar utilising dual axis charts and reference lines
For there are four measures,I konw I can put them in one chart with lines in different colors,but how can I get the chart with four different kinds of chart? just like the picture on the above.
1- build a dual axis chart.
You simply need to drag your measures into the row/ column shelf. Right click the second measure you dragged in and tick "dual axis". You can then play each measure chart type on the side.
2- Combo chart:
You can add other measure simply drag them on top of one of the axis and add as many measures as you like into your chart, however you won't be able to change the chart type individually.
3- Reference line:
If you want to had a “fake” bar chart to this dual axis / combo chart you can drag another measure onto the detail mark card and use as a the reference line. For that add a reference line (right click on the axis) and choose the color to fill below (also get rid of the computation > label set to "none").
Hope this helps!
Thanks John.It works!
Best wishes !
best wishes for you
Sure Zhou, Glad I could help.