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...
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"...
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...
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...
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...
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?
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...
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...
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...
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...
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".
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.