Adding Colour Scale to Straight Table Data

[#1]

Hi

I have a straight table

Team                    Sales 2013     Sales 2015     Sales 2015

Team A

Team B                                        data

Team C

Team D

I want to implement a colour scale to the background of the data.   (Like in Excel)

Any ideas?

Thanks

T

[Gysbert_Wassenaar]

See this discussion for one option, using the colormix wizard.

[#3]

This is great Gysbert!

This only only takes into account colours for  Sales 2013 though.   If I replicate the steps for Sales 2014  then it colours them based on only the values in Sales 2014.

I want the color mix to reference all expressions - i.e ( Sales 2013, Sales 2014 and Sales 2015) at the same time.

Any ideas?

[Gysbert_Wassenaar]

Try creating an example document so we can have a look: Preparing examples for Upload - Reduction and Data Scrambling