3 Replies Latest reply: Sep 2, 2014 5:41 AM by Yeo Poh sai

# How to convert table to chart ?

Hi All

In my previous post , the information i give is not so clear , so i try to post again :-

I need to plot the Table A 2 value 2,579,737 and 563,620 at chart A.

So my chart will display 2 bar , one bar = 2,579,737 another bar will display 563,620

Hope some one can advise me.

Paul

• ###### Re: How to convert table to chart ?

Enclosed my QV doc

• ###### Re: How to convert table to chart ?

Create a bar chart...

DIMENSION

NO DIMENSION

EXPRESSIONS

NUM(SUM(IF(CURRENCY='EUR',TOTAL*1.64,

IF(CURRENCY='NT',TOTAL/24,

IF(CURRENCY='USD',TOTAL*1.25,

IF(CURRENCY='YEN',TOTAL*0.012,

IF(CURRENCY='SGD',TOTAL*1))

)))),'#,##0')

NUM(SUM(

IF(CURRENCY='EUR',DAY30*1.64,

IF(CURRENCY='NT',DAY30/24,

IF(CURRENCY='USD',DAY30*1.25,

IF(CURRENCY='YEN',DAY30*0.012,

IF(CURRENCY='SGD',DAY30*1))

)))),'#,##0')

• ###### Re: How to convert table to chart ?

Hi Manish

NUM(SUM(IF(US_Cust='EU',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))*1.64,

IF(US_Cust='NT',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))/24,

IF(US_Cust='USD',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))*1.25,

IF(US_Cust='YEN',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))*0.012,

IF(US_Cust='SGD',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))*1))

)))),'#,##0')

But i have another table , with out provide me the total amount , i try above expression , it reutrn null value. any advise ?