how to create different bin range using class function

[eliko_il]

hi all,

assuming i have this table:

col1	col2
A	272
A	214
A	483
B	457
B	278
B	327
B	363
A	324
B	433
A	153
B	596
A	350
A	153
B	520
A	343
B	325
A	433

I want to create bar chart with x-axis as the following bin range:

<200 , 200-250, 251-300,301-350, 351-400, >400

i try the class function (  class(col2,50)  ), but i need the option to create also min range (<200) and max range(>400).

In the class function it create with final range.

The y-axis  just count freq of A according to the bin range.

does anyone have a solution (without change or add any data to the DB)?

thnx.

[Gysbert_Wassenaar · Accepted solution]

Try something like this:

=if(Col2<200,'<200',if(Col2>400,'400',class(Col2,50)))

[eliko_il]

thnx Gysbert, but i still have 2 problems:

First- i want to sort the x-axis as: col2<200,200-250,251-300, .... , col2>400 i try sort by expression but it didnt work.

Second- i want to color the min col and the max col with different colors than the rest of the cols.