• 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

    Using access to store data for excel dashboard

    I think I'll be holding off on Northwind for now. Won't make a decision right now. But thanks for your offer of assistance. It's appreciated. Dan I wanted to ask you, when you enter the data in Excel using SQL is the data automatically updated when you add data in Access. Example say in Acces...
  2. K

    Using access to store data for excel dashboard

    No. The company uses only excel files saved on a shared drive. Is NorthWind a free software? Is that what you use?
  3. K

    Using access to store data for excel dashboard

    At work I have Excel 2010, at home on my laptop I have Excel 07 (I carry work home sometimes, bad practice....I know.
  4. K

    Using access to store data for excel dashboard

    Ok. Well I'm not familiar with what MSquery is, so I'll research that one. With regards to how I enter the data now in excel, I have the name of the KPI spanning cell A1 to B1 (i merged the cells) (example Sales), then in A2 i have the word "Actual" and in cell B2 i have the word "Target"...
  5. K

    Using access to store data for excel dashboard

    Dan: Thanks. It's just so unbelievable how different persons go about things in different ways. I was not thinking at all about having a table for each KPI, but this is another approach I can consider. I would have to find a way to make it easy for users to enter the data in the different...
  6. K

    Dashboard with unrelated KPIs

    Narayank991: The KPIs have been entered in a seperate excel worksheet Excel, while the dashboard is in anotehr worksheet in the same file. The persons who have the KPI data (eg. someone form accoutns would enter the financial data) are responsible for going in the file and updating the KPI...
  7. K

    Using access to store data for excel dashboard

    Dan_I: Thank you for further insight. Found the website useful. Following Clarity's comment I downloaded an Access Tutorial Video and have been watching to reaquaint myself with Access. I also got Mike's book, which I'll go through a I have a little concern. Let me ask though in Access, do...
  8. K

    Using access to store data for excel dashboard

    Thanks a million. Very helpful and informative.
  9. K

    Using access to store data for excel dashboard

    Does anyone store their data in Access and use excel only to generate the dashboard? Is this the best method? What are the advantages and disadvantages of doing this? Where can I find information on how to get this done?
  10. K

    Dashboard with unrelated KPIs

    Thank you Fred. I will try to hold a discussion with the stakeholder.
  11. K

    Dashboard with unrelated KPIs

    I'm trying to create a dashboard for over 30 KPIs which are organized by the balance score card perspectives. The user wants to see all the KPIs arranged by their balanced score card perspective. Problem is the KPIs are so different and measured in different units (eg dollar vs percentage)I was...
  12. K

    Using Option button in MCQ test. Want to select option for each question.

    Thanks guys, I tried ypur suggestion but for some reason its not workiong, is there something that i need to do before or activate to make it work?
  13. K

    Using Option button in MCQ test. Want to select option for each question.

    as we know only one Option Button Form Control may be selected at a time, the remainder are automatically turned off. Now this poses a problem as I am setting up a Multiple Choice Quiz consisting of 10 questions. Problem is when I select the option for question 1, and then move to select the...
  14. K

    How far is a number in a range/series

    It works. Thanks a million guys. I love this website. :)
  15. K

    How far is a number in a range/series

    I would say Fred interpreted it correctly. I wanted to know what position the 8 is in. Thanks guys. Will try it out and see.
  16. K

    How far is a number in a range/series

    I have a list of numbers eg 1 5 3 8 5. What formula will tell me that number 8 is the 4th number in the series
  17. K

    A simple IF statement fails me

    Make sure the word sandanona is spelled correctly. That could be a problem
  18. K

    How to show row base on month selected

    I have a file that is updated monthly. There is a data validation used to select the month and then persons procedd to update the rest of teh information. Problem is teh file has to be saved every month as a different file name. What I want is for all teh information to be saved in one file and...
  19. K

    Moving average using named range

    Luke, that is teh post I am refering to. The range I have is dynamic. The user select the KPI they want to view, so it's not going to be in the same column at all times. Secondly say the named range "Y_Axis" runs from A1 to A30, then I want to forecast cell A31 as the average of the last...
  20. K

    Moving average using named range

    I saw Chandoo post on calculating a moving average. Does anyone know how to do it using named ranges. Additionally I want to forecast 1 period ahead using this method. How can this be done using named ranges. My actual data is in a named range "Y_Axis".
  21. K

    Connect two line graphs?

    I don't know how to tell excel that for the last value in the actual column the forecast column must have that same value too.
  22. K

    Connect two line graphs?

    Hui: Can this be done using name ranges?
  23. K

    when the two don't meet

    From what I know, the SUMIF function will produce a single number as the answer. It will not be giving you a series of data or array for you to plot.
  24. K

    Show legend only when series is selected.

    Luke M: Thanks for your suggestion. I removed the legend. I placed a data label at the end and edited it with the word "Actual" and "Target" and coloured the words appropriately.
Back
Top