How can use single ( Monochrome ) color to block chart

[vlakeshr]

I have plot block chart and I want to use Grey color in block chart on the basis of minimum count to maximum count.

I have data and containing order no. i want to show light grey for minimum order count and Dark to maximum order count . Light to Dark on the basis of order count.

I used expression in block chart for calculating % in block chart

=Count({<Table={'ORFT_comment_tbl'}>}Order_Number)

Color code are below

Set vwg1= rgb(220, 216, 214);

Set vwg2=rgb(197, 190, 186);

Set vwg3=rgb(173, 165, 158);

Set vwg4=rgb(150, 139, 131);

Set vwg5=rgb(124, 113, 105);

Set vwg6=rgb(97, 88, 82);

I want to show monochrome color code ( War Grey ) like

=if(Order_Number<10,$(vwg1),

if(Order_Number<15,$(vwg12),

if(Order_Number<20,$(vwg3),

if(Order_Number<30,$(vwg4),

if(Order_Number<50,$(vwg5),

$(vwg6))))))

Table Query is as below

ORFT_comment_tbl:

CrossTable(Status,Value,10)

LOAD Order_Number,

     MAN_Contry_Code,

      Comment,

     If(MAN_Contry_Code='KO','Kolumbia',ApplyMap('CountryMap',Upper(MAN_Contry_Code),'Not Defined')) as Country,

     ApplyMap('RegionMap',Upper(MAN_Contry_Code),'Not Defined') as Region,

     ApplyMap('Operatingcountrymap',Upper(MAN_Contry_Code),'ALL') as [Operating country],

     ApplyMap('Region_originalmap',Upper(MAN_Contry_Code),'Not Defined') as Region_original,

      USERID,

     'ORFT_comment_tbl'as Table,

     Date(DATE_Auto,'DD-MM-YYYY') as %DATE_KEY,

        //TIME_Auto,

    // Region,

     Credit_block,

     Incomplete_BOM,

     Legal_block,

     Order_placed_inside_DLT,

     Order_placed_without_matching_forecast,

     Other,

     TL_ULO_not_respected,

     ATP_fails,

     Wrong_missing_Incoterms,

     Wrong_missing_payment_terms,

     Wrong_missing_price,

     Wrong_missing_route,

     Wrong_missing_vendor_info_record

FROM

[\\FRIAPFIL04.EAME.SYNGENTA.ORG\Poland$\SCM\ORFT_comment_tbl.xls]

(biff, embedded labels, table is ORFT_comment_tbl$);

ORFT_comment_tbl_1:

NoConcatenate

LOAD *

Resident ORFT_comment_tbl

Where Len(Trim(Value)) > 0;

DROP Table ORFT_comment_tbl;

Concatenate(ORFT_comment_tbl_1)

ProcesIssue_comment_tbl:

LOAD

Order_Delivery_number  as Order_Number,

     Country_Code,

     Who as [Team Responsible],

     Issue_type,

     Comment,

      ApplyMap('SupportMap',Upper(Order_Delivery_number),'Not Defined') as Plants_Name,

     If(Country_Code='KO','Kolumbia',ApplyMap('CountryMap',Upper(Country_Code),'Not Defined')) as Country,

      ApplyMap('RegionMap',Upper(Country_Code),'Not Defined') as Region,

  ApplyMap('Operatingcountrymap',Upper(Country_Code),'ALL') as [Operating country],

      ApplyMap('Region_originalmap',Upper(Country_Code),'Not Defined') as Region_original,

     USERID,

    Date(DATE_Auto,'DD-MM-YYYY') as %DATE_KEY,

     'ProcesIssue_comment_tbl' as Table

//     TIME_Auto,

//     Region,

FROM

[\\FRIAPFIL04.EAME.SYNGENTA.ORG\Poland$\SCM\ProcesIssue_comment_tbl.xls]

(biff, embedded labels, table is ProcesIssue_comment_tbl$);

Can you please suggest how can use monochrome color ( like Heat map color light to Dark Color ) for block chart, appreciate for your quick response.