combo chart with multiple Xaxis

[liliachante]

Hi, I want to make a combo chart with 3 variable on a x axis but I don't know if  it is possible I have data for 6 years 2011-2016, and these years will be on a x Axis but on the same axe I Want to add sum and average Do you think is it possible to make it?

Thanks in advance,

Best regards

[v-xicai · Accepted solution]

Hi @liliachante ,

You may add the SUM and AVERAGE created using column instead of measure into X axis box of your combo chart, while it looks like a little weird to have different mixed type arguments in X axis at the same time. Recommend you put the SUM and AVERAGE measure into Line values.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.