• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. W

    Excel 2010 Remove Data Connections, keep the data, combine monthly workbooks.

    All, Dept 1 are downloading data into excel on the 1st of every month from an SQL db. This is their archive solution since the SQL database is always current and doesn't or can't hold historic data - just not been set up that way. I've created an excel dashboard (excel 2010 workbook) using...
  2. W

    Conditional Format Pivot Table Row

    Thanks for that, it seems to work. Although the conditional formatting doesn't seem to extend across the row labels too. If I change this apply this option to include the label row. I receive the following error: cannot apply a conditional format to a range that has cells outside of a...
  3. W

    Conditional Format Pivot Table Row

    All, I have a pivot table which connects to external data and refreshes on opening. I can conditional format cells based on a value, yet how can I conditional format entire rows based on a cell value? I want to actually hide the referencing column/cell value, but still somehow be able to...
  4. W

    Excel 2010+Pivot Table Conditional Formatting

    All, Struggling to figure this one out. I have a pivot table with a column label which is a date field (assignment finish date). My values are a count of the assignement finished date. i.e. How many assignments were finished on day X? I need to conditional format my value field counts to...
  5. W

    Excel 2010+Pivot Table - Auto Expand Drill Down Data

    All, Pretty new to dashboards. My dashboard is one pivot table, with various columns. I know that if you expand on a value in my pivot table, it drills down and you can see what is behind the value on a separate worksheet. Can you get the drill down to happen automatically? I have a...
  6. W

    Data Label or Group Relationship Flow - Parent Child Relationship

    Luke M. Thanks, If I'm put into a group, because I'm already in that group, which other groups am I in as well? If I start by selection my location i.e. London. Then I'd be shown a list of possible departments specific to that location. i.e Tax,HR,Marketing. Then if I select Marketing...
  7. W

    Data Label or Group Relationship Flow - Parent Child Relationship

    All, Pretty new to Excel (2010). Yet, really enjoyed the brief training I've had. Now everything is - must be able to be done in excel. I've data - "groups names", extracted from LDAP in an excel format. I'm thnking about a flow chart to show the top level and how by placing X in a certain...
Back
Top