dashboard

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

Dear Experts, Please assist on this request. I kindly need the codes for extracting TURNS for a specific date and time from the database to Dashboard sheet under column B. (26/11/2018 06:01:00 to 26/11/2018 17:59:00) Should i extract the values from RawData or PivotStage sheet? Please advise...

Hi Guys, How can i remove the Grand total value in "DASHBOARD" sheet when i hit a macro? Is there anything missing? Please let me know. Thank you. https://www.excelforum.com/excel-programming-vba-macros/1255199-to-remove-grand-total-value-in-dashboard-sheet-at-the-last-row-of-column-a-and-b.html

Dear Experts, I'm pretty much a newbie on VBA. I really need your expertise for below case:- I need to transpose the values/TURNS from PivotTable1 to Dashboard sheet under column B by using macro. Codes are already written but i'm facing an error on "REF". Is there something missing from my...

Here is an example of a dashboard I created and I need help merging multiple dashboards into one PDF in excel. https://pasteboard.co/HNV3cgL.png This dashboard is a summary for one employee, but we have 50 employees. To change the employee to another, I am using a slicer, which then changes...

I know you can take a pivot table and create multiple tabs that change by the filtered range. For example in a pivot table you can have a monthly report but you want to show a monthly report for multiple people. I have a dashboard (an excel page with multiple pivot charts on it), that has...

Hi, I have code to export a series of charts from a dashboard to images. The intention is to then disply them on TVs around the building I have code that will do that (HTML) but the charts are tiny :( They are nicely laidout for the dashboard but I need larger images for the TV Is there a...

I have two different dashboards in the same workbook. The problem is I can´t get the slicers to work individually for each dashboard page, if I filter on one dashboard it´s affect the other one aswell. I have created all diagrams from the same pivot table. Maybe I have to create a new pivot...

Hey everyone, Hope everyone is having a great day :) So I am trying to create a sales dashboard using pivot tables and charts. I have a pivot table in the dashboard that shows the top 10 selling items in the selected category, then I had a great idea to add a section next to it that would show...

Are there any sale dashboard templates people use that they could share? Particularly interested in Speedometer Radial type graphs. I.e green is good, yellow ok and red is bad.

Hi Guys, Really need help asap - work project. https://docs.google.com/spreadsheets/d/1_sv65EOBbgGqfcMtF7L6rSEl_Iba7NAX56mK6O1Ns2o/edit?usp=sharing On the Data for Dashboard tab I want it to =Query data from the main data, depending on what option are picked in the dashboard sheet (REP...

Hello. My boss give me a raw data and ask me to create a dashboard with function like: If I type the tax ID from a search box (for example) it will get the profile of that tax ID from Raw data and display it in a dashboard. Any idea how should I start and what typle of dashboard I should...

[CODE]Private Sub cmdPrint_Click() ''

Hi All I have created a dashboard using excel. I will be displaying the dashboard on anoffice TV. I have around 5 differentworksheets on the dashboard and I want to switch between the worksheetsautomatically say every 10 minutes and loop back to the first before repeatinguntil the...

Good Day, Need your help on this, I'm making a dashboard, my problem is my vlookup is not retuning to blank instead it displays 0%. My formula is: =IFERROR(IF($B$4="",VLOOKUP($A$4&$C8,PIVOT!$A$5:$AC$472,DASHBOARD!D$1,0),VLOOKUP($B$4&$C8,PIVOT!$A$5:$AC$472,DASHBOARD!D$1,0)),"") Thanks.

Hi everyone I am trying to create a one page dashboard style document. The document contains a number of individual sections with data. I have added a custom scrollbar for each section so that I can include all data, and not say, the top ten. I have done this using the OFFSET function. In a...

It's Friday Evening and my brain is melted, I can't think and this is providing me with errors which is incredibly frustrating...

I have a dashboard works now with tables, ranges etc. However, I want to improve it by linking excel tables to access queries (as opposed to copying and pasting). However, when I do this the array formulas I use in the dashboard stop working. Do array formulas not work with tables made from...

I have a manual table which will be updated with new countries/states every 6 months or so. Once we update the countries/states, it will auto update a dashboard and the formulas associated with it. Example: <tbody> Region 1 APAC Region 2 US Region 3 EMEA Country 1 Japan Country 1 Florida...

Hello, let's say I'm doing a COUNTIF across two sheets. The first sheet is Dashboard, the second is data. The formula is being entered on "Dashboard" When I am flicking between the two sheets as I fill in the range and criteria, I end up with something like: [criteria_range1] [criteria1]...