Results 1 to 2 of 2

Thread: Discovering Dashboards in Excel 2007

Hybrid View

  1. #1
    Join Date
    Aug 2013
    Posts
    1

    Thumbs up Discovering Dashboards in Excel 2007

    Thanks to Helen Bradley for her step-by-step article published on 6th June 2008. I'm completely new to Dashboards and this article has helped me understand them a bit better.

    I have a couple of minor pickups that stumped along the way:

    On page 1, when I typed the expression =OFFSET($B$3,CHOOSE($H$1,0,1,2),0) into Excel 2007, there was an error message. Replacing the commas with semi-colons fixed it.

    Also on page 1, just below the above formula, there's a paragraph on generating formulae in the table H3 to K6. Following the instructions gives the same data across the four columns but, if one of the $ symbols is removed from the first OFFSET parameter in each row of the H column (B$3, B$10, B$17 & B$24) then the correct data is extracted when these formulae are copied through to the K column.

    Hope that's clear.

  2. #2
    Join Date
    Apr 2011
    Location
    Largo, FL.
    Posts
    433
    Guessing that you are referring to this-> http://www.smallbusinesscomputing.co...Excel-2007.htm

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •