Hi Haocheng Li,
Yes, it is possible to have a chart with multiple lines and areas. Is this what required ?
So yes it is possible, but this exact chart is a little complicated to do (I'm excluding the requirement for "dotted" lines, which aren't available "out the box" in Tableau, but like all things we've come up with workarounds, but add even more complexity).
Attached are 2 versions...one using the data source as is, the 'Original' tab. I've gone for the simplest method, which is to use reference bands for the Grade 1/2 boundaries, but the compromise is they are blocky.
On the 'Pivoted Tab' I've reshaped the data, with Tableau's built in Pivot function. I've then added some calculations, so I can use the Area Chart type to get the bands. Let me know if either of these flies for you and I can go into a bit of detail on the setup and calculations. As we can only overlay (dual) 2 axis in Tableau we have to get a little creative.
A fun little challenge!!
Combined Measures Chart.twbx 50.8 KB
Sorry for the later reply, it really took me much time to understand your resolution.
It is really a brilliant way to present such multiple measure.
Thank you so much for your great support.
Thanks & Regards,
Excellent glad it helped, and good work on reverse engineering it!!
...yes the key is to use the Area Chart, and make the bottom segment the same colour as the viz so it becomes "invisible"
Here are a couple of other examples of this technique