Skip to main content

Hi,

 

I have a data set like below.

 

LocationTotalAMPTLALine1Line2Location11114151614Location23125241612Location34332131913Location4133911176Location52013131510Location61524242010Location7416211113Location84611201414Location93279159Location10199181011Location1127813188Location12113125109Location134337171312Location14272891910Location15432713175Location16412523129Location17321020106Location18474231213Location19343817178

 

the chart I am trying to create is as shown in the attached item.

 

The challenge here is that Multiple measures are used for creating the bar chart and there should be 2 lines on top of the bar chart that lines should come from two columns.

Can anyone please try to create the same chart without changing the structure of the data.

 

If this is not possible which can be the best alternate solution to represent this type of the data.

 

Regards,

Philip George

2 answers
0/9000