Default for stripes every 10 rows

[tinkerz1]

Hi,

In the chart properties under style>Stripes every 10 rows.

If I change the rows to greater than 10, QV defaults back to 10 for straight tables.

How can I keep the stripes to my number?

[HirisH_V7]

Hi Check this,

Expression,back Ground Color,

=if(mod(RowNo(total),10)=0,lightgreen(),lightblue())

HTH,

PFA,

Hirish

[Chanty4u]

nice..hirish

[tinkerz1]

Hi,

That looks great but its in a pivot table not a chart.

[HirisH_V7]

Hi

check this,

Same Expression but ,Change type of chart.

PFA,

HTH,

Hirish

[tinkerz1]

Hi, I was after stripping every other 16 rows, so blocks of alternating stripes, the first 16 begin white then the next 16 grey, then the next 16 white etc.

Thanks

[tresesco]

Try background color expression, like :

=Color(Floor(RowNo()/16)+1)

[HirisH_V7]

Hi Tresesco,

It works,If we want only two colors means !

-Hirish

[tresesco]

Then, something like:

Color(Mod(Floor(RowNo()/16),2)+1)

[HirisH_V7]

Thank you very much tresesco  ...Its working

-Hirish