• 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. K

    How do I apply a filter to columns instead of rows?

    Aditionally I want to be able to see all the columns if I want or two or more columns. It has to be flexible.
  2. K

    How do I apply a filter to columns instead of rows?

    Thank you for your comments. Debraj Roy: Yes that is what I want to accomplish. Do you know if it can be done without coding? Bobhc: As I understand pivot tables they give you a summary report of your table. This file will be used by the persons monitoring the risks who will have to update...
  3. K

    How do I apply a filter to columns instead of rows?

    I'll try to explain with an example. I have a risk log which is now to be used to monitor/track the risks by providing monthly updates on the project. The risks are listed going down the rows and i want to have a column for each month going across. The project is for 12 months so the fist month...
  4. K

    How do I apply a filter to columns instead of rows?

    Good afternoon: Does anyone know how to apply a filter to columns instead or rows? Is it even possible? Thank you.
  5. K

    Using Access to collect data for excel dashboard

    Montrey: I did it manually. 1. Write click on the name of the query/table from the navigation pane 2. Select Export ---> Excel 3. Choose a file name 4. Select the box for "Export data with formatting and layout 5. Select teh box for "Open destination file after the export operation is...
  6. K

    Using Access to collect data for excel dashboard

    I would like to express a big thank you to Dan who guided me in setting up an Access database. The database is stored on a shared drive. I created a query that collects the data from various tables and I then export the data to the input worksheet in the file containing the dashboard. Access...
  7. K

    Create an array of every other column_See MOD formula which does not work

    SirJB7: I adjusted the formula as follows to create a name range "Actual": =INDIRECT(ADDRESS($B3,(COLUMN(Expenses)-1)*2,4,TRUE,"Sheet1")) I added the name range "Expense" in the column formula but it doesn't work. Can you help?
  8. K

    Create an array of every other column_See MOD formula which does not work

    SirJB7 we're getting closer. The next thing I wanted to do was to get that formula =INDIRECT(ADDRESS($B3,(COLUMN()-1)*2,4,TRUE,"Sheet1"))as a named range. I want the formula to be dynamic. As it is now I would have to copy over the formula as the months progress. I think the trick to getting...
  9. K

    Create an array of every other column_See MOD formula which does not work

    SirJB7: Thanks for your efforts but I wanted a formula that would do the trick instead of manually selecting the cells. The spreadsheet will be growing so i want the graph to be updated automatically.
  10. K

    Create an array of every other column_See MOD formula which does not work

    See link. The file name is "Select every other column" https://skydrive.live.com/redir.aspx?cid=16d0ed9ee1cb5b75&resid=16D0ED9EE1CB5B75!113&parid=16D0ED9EE1CB5B75!102&authkey=!AFA90w3_C_BAAHc
  11. K

    Create an array of every other column_See MOD formula which does not work

    I have data in 4 cloumns. Starting from column A the numbers are: 10, 20,30, 40 I want to create a named range which will give me the first, and third numbers meaning it would give me numbers, 10 and 30. This is the formula I have: =MOD(COLUMN(A1:A4),2). I called the named range "Actual"...
  12. K

    Using access to store data for excel dashboard

    Dan: 1. For some KPIs teh targets vary by the month, for others they are fixed for the year and do not change. 2. Info for the dashboard: - name of kpi - value for the month - target for the month - target for the year - comments - initials of the person who has responsibility to update...
  13. K

    Using access to store data for excel dashboard

    Sorry for the late response. See link to file on skydrive: https://skydrive.live.com/redir.aspx?cid=16d0ed9ee1cb5b75&resid=16D0ED9EE1CB5B75!112&parid=16D0ED9EE1CB5B75!102&authkey=!AJgQ-3IQHwqwpoY
  14. K

    Using access to store data for excel dashboard

    Dan: Me again :). So another question for you. In your database do you establish relationships between your tables? This is what is wanted of me. As I mentioned earlier each KPI falls under a balanced score card perspective. For example the KPIs named "Assets" and "Expense" are financial...
  15. K

    Interactive Excel charts (Crosshair)

    Thanks Narayank991
  16. K

    Interactive Excel charts (Crosshair)

    @Narayank: Thanks. What did you change so that the months are now showing? I realize though that the green point isn't in line whith the line graph. I'm wondering if it is related to the change you made
  17. K

    Interactive Excel charts (Crosshair)

    @ Narayank991: Thanks for trying to assist me. Try this link. Copy and paste the link below: https://skydrive.live.com/redir.aspx?cid=16d0ed9ee1cb5b75&resid=16D0ED9EE1CB5B75!111&parid=16D0ED9EE1CB5B75!102&authkey=!ANLWF325ShAm7fc
  18. K

    Interactive Excel charts (Crosshair)

    Guys I tried Narayank991 suggestion see file: https://skydrive.live.com/?cid=16D0ED9EE1CB5B75&id=16D0ED9EE1CB5B75!102 The problem I'm having is that I want the X Axis to show the month and year from B3 to B10. It is currently showing the comments information in column A (so I deleted it)...
  19. K

    Using access to store data for excel dashboard

    Ok. Glad you agree. Next question: What is the Primary key that you use in your Access Database. I'm thinking that if a table is used to enter each KPI (in my case I would have 30 tables) then I'm not seeing what would be the primary key since the tables wouldn't be related to each other. What...
  20. K

    Using access to store data for excel dashboard

    Thanks Dan. I'm not verse with SQL, so I'm like a beginner, so these tutorials will be very helpful. Will start going through them now. Next question: Do you narrate somewhere whether in a Word document or in Access itself how your file is structured or was created? For instance do you...
  21. K

    Using access to store data for excel dashboard

    I just saw a video which shows that Access 2010 has what is called a Navigation Form. I believe it replaces the switchboard. I'm thinking it can be used. I'll have the list of KPIs on buttons to the left and when they click they get to view the form to enter the data for that KPI. So there will...
  22. K

    Using access to store data for excel dashboard

    Dan: I just finished watching some videos on switchboards. I think that's exactly what I wanted and it can be used. I want your opinion on something. Now remember I said there are like 30 KPIs. Now lets say there are 5 users, each updating 6 KPIs monthly. I'm trying to think how I would make...
  23. K

    Using access to store data for excel dashboard

    I just love talking to you. I just keep on learning. I'll definitely look into that. I wasn't familiar with the switchboard option, and I think that does the trick nicely. Thanks a million Dan, you are quite knowledgeable.
  24. K

    Using access to store data for excel dashboard

    I want to ask another question. Tell me what you think of this idea. I'm thinking to use infopath to create a user interface in sharepoint,users would use this to enter the kpi data. Have infopath send the data to access. The data will then be exported to excel from access to create the...
Back
Top