Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

1. Staying in Control > Making the spreadsheet more readable with colors

Making the spreadsheet more readable with colors

To make clear what the exact purpose of a cell is we need a set of guidelines to follow.

Getting ready

You need a basic Dashboard Design dashboard containing a few components in the canvas with some bindings to the data model in the spreadsheet.

How to do it...

  1. Go to your data model in the spreadsheet.
  2. Select the cell(s) you want to color.
  3. Click on the Fill Color button and select the desired color. You can find this button in the Font section of the Home tab.
  4. Color the cells that have dynamic visibility values in orange.
    How to do it...
  5. Color the cells with input values from canvas components yellow. In the following screenshot, row A3:N3 is used as the destination range for a drill down from a chart.

  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint