charts

[#1]

Hi

i have an excel and only have one row of value as shown in below image.. from the highlighted two columns i want to generate a chart as shown in the 2nd image.. i did try many ways but i just cant take the expected value.. can some one plz help me...

thank you in advance

[ashfaq_haseeb]

Hi,

Can you post your sample file with Excel data.

Regards

ASHFAQ

[#3]

sorry 4 getting late this z the test quv n my excel.. i have done nothing actually in the quv cz i want to get this chart done

[MarcoWedel · Accepted solution]

Hi,

maybe like this?

LOAD
F2          as Date,
[Calls
Hand
< SL*]      as [call answered],
[Calls Aband
< SL**]     as [call abandoned]
FROM [http://community.qlik.com/servlet/JiveServlet/download/535000-107929/icd_contact_service_queue_activ...]
(biff, embedded labels, table is Sheet1$);

just select stacked bar chart:

hope this helps

regards

Marco

[#5]

sorry for late reply but this worked perfectly thank you so much