dashboard

Can anyone help? I am attempting to capture a percentage of a count in a column in a pivot chart. Example: In January 3000 customer service calls were made. Of which 300 were unresolvable. I am attempting to capture what percentage of January's calls could not be resolved and display it on a...

I've inherited an Excel document that is used to keep track of where materials are located within out facility. Recently they asked me to include quantity counts and mark them red when quantity gets low. This part wasn't hard, simply used a <count-if> function, then set conditional formatting...

Hope you are all having a great day! I have a dashboard with 6 slicers. Some combinations of slicer selections have very little data and when I make those selections, Excel simply closes down (and it doesn't have any list of recovered files when I re-open Excel.). I don't think my customers...

I'm building a simple dashboard with command buttons to open other excel sheets from this central dashboard. I'd like to display next to each button whether the excel workbook being opened is already open and by which user. Is this possible?

Ive always appreciated the assistance of you all, and i need a little more assistance: In the past only 1 person in our office is responsible for uploading new jobs or correcting/updating existing job milestones in our PM job log. However, we've gotten to the point, where this is too much for...

I hope somebody can be of assistance as i am rather lost. My issue is the following. The company is deploying a custom excel dashboard to access file shares and incorporate several quote forms that the user can fill and save the information. The xlsx dashboard and fileshare directory is...

Is there any way to create a dynamic list in shapes? For eg. I have a table with follow up dates against the companies. I want to insert a to do list in the dashboard where the user can select a date and he can view the list of companies that needs to be followed up with on the given date. I am...

I am wondering if I can get suggestions from the experts here how best to proceed. I am trying to take my companies 10 sales goals and turn the monthly data into a dashboard so that my boss can quickly view progress. Each goal has a production number, goal, and deficit/surplus to goal. The goals...

Hi all, I have looked online but can't seem to find an answer to this. I have currently filtered the date by specific year which looks like below. What I am trying to do is use a slicer so that I can choose between dates and also get a text return linked in but I cannot seem to figure out how...

Hi, I have a SUMIFs statement that works but as it pulls data form an external sheet, erros out if I don't have both sheets open when I update. I rarely use sumprodcuts but followed a guide to convert it and I get a value error. This is my original SumIf and resulting SumProduct. CAn anyone...

Hi there, I was wondering if someone could offer a novice a helping hand? I'm pulling together a dashboard to display, amongst other things, the cumulative daily % variance of actual v target. I have the days of the month in A2-A33 and the actual cumulative +/- % in F2-F33. The only thing I...

Hi All, I am making an excel dashboard about players performance. I have inserted a slicer (with the names of the players in it), so when I click on it, the different graphs show for this person. But I also want to have the pictures of the players inserted in the dashboard when I click on their...

Hello Friends My name is Kaustubh Patel and this is my first post in this forum. First of all thanks for creating such a beautiful and helpful community. Please note, I am not an excel or VBA expert but with the help of Google, I learned how to create and edit basic VBA code. Now coming to my...

Hi, I am by no means an expert in MS Excel, but most of the times I can find the solutions myself. Not this time... I want to track all the changes in our headcount:* All the dates employees were hired, which position they were hired for, and which team they belonged to* All the dates...

Hi, am hoping someone can point me in the right direction... I have created an excel based audit tool for hospitals. It takes scores from staff and managers in response to around 30 questions. These are combined and triangulated to produce a lovely dashboard / performance summary... All good so...

I have a dashboard type workbook that has buttons I press which I use to navigate between sheets. On the main dashboard there are a few numbers which I have used vbscript to type. For some reason when I navigate to other sheets these numbers show through from the main dashboard sheet. I dont...

Hi I'm making a dashboard where I import raw data reports from an old fashioned ERP system into different sheets. The dashboard sheet then retrieves and calculates different results and combines these into 1 view on 1 sheet.To find the top performing customers YTD, the dashboard retrieves it's...

I am making a dashboard in excel, and I have been stumped as to if this is doable or not. I have 2 sheets, one with data and one with a dashboard that I am making. I have the id# for each individual user in one field (g4) and use that to populate the data in the rest. I have 6 Error Columns S:X...

Hi, Tried to look this up but i couldt make the other threads relevant. I need to copy content (E17) from a sheet named "Dashboard" to a sheet with the name same as value in cell c17 in "Dashboard" Then i want to paste it in the next empty cell under cell C26 How do i code this in vba...

Good day, I need either a function or macro that will give me the last numeric value of any column of data. I have read the threads related to "=LOOKUP(2,1/(A:A<>""),A:A)." However the above limits me to column A and I don't have the skills to change it to give me what I need from other columns...