# dashboard

1. ### Gauge chart - help with changing range to non zero start

I am trying to update a gauge chart that I made in excel to show a different range (50% to 100%) The chart is currently done on a scale of 0% to 100% with the following input calculations: Range Start: 0% Section 1: 97% (input value given) Section 2: 3% (calculation is 100% minus 97% from...
2. ### Is Excel Fine or Should Go Somewhere Else?

Hi; I made a workbook which contained the data of equipment (A to AZ) available from a Facility with 6 additional columns which has the latest maintenance date that is inputted by the maintenance foreman. In which the next date maintenance should be done is shown how close it is and a color...
3. ### Countifs - Multiple Conditions (HR Dashboard)

Dear Team, I am currently working on an HR Dashboard and I want to be able to use a formula to do 2 things: A. report the overall current number of employees who are still onboard. This will mean as long as I keep updating the datasheet this number should automatically be updating...
4. ### Guidance: Data table setup for Dashboard (Pivot Charts) Output

Hi, Looking for guidance to create a Dashboard for quanties of stock, cashflow and other KPIs. I have table of data where: Column A = Date (ordered, earliest to latest) Column B = "In" or "Out" (if it's stock received or stock dispatched) Column C = Product code (e.g. 1, 2, 3, 4, 5) Column D =...
5. ### Filter Data on one sheet with dropdown list from another sheet

I have an excel file with 3 Sheets - Dashboard, Funnel and DDL The Dashboard is used to display the summed up data from the funnel sheet The Funnel is used for user entry DDL - is my sheet uses for drop down lists What i would like to do is on the Dashboard sheet, add a drop down (which i have...
6. ### VlookUp

I have a table with multiple columns. I am wanting to search one of those columns to find if there is a value > 0. If so, I want it to return back to a main table dashboard that value in one column and in the second column, it will return the number in the column it was searching. It would...
7. ### Match multiple criteria returns a specific result

I am trying to build a vacation scheduler for a staff of approx. 100 staff and most of it works fine but I can't figure out one last piece. What I have is a dashboard, a staff list, a vacation list and then a DOR (day of rest) list. The dashboard has each employees name in B9:B100 Dates are...
8. ### Excel worksheet in Teams

Hi all, My workplace has recently moved across to O365 and use Teams. Within our Sharepoint file structure/Teams, we have a workbook that is manually updated each week. In the workbook, I have a sheet, called 'Dashboard'. On it there are a series of view only charts. Does anyone know how I can...
9. ### Pull a specific data range from spreadsheet and offset when the month changes??

Good afternoon all, I want to select 3 columns of data from my spreadsheet which will be displayed in a chart on my dashboard, for example Column headers are Jun 19/Jul 19/Aug 19, when I get in to the month of September I want the selection to move along one column and then select Jul 19/Aug...
10. ### Pivot table auto refresh, live dashboard update

Hi, I have a data table turned into a pivot table. I want to use this pivot table to drive a dashboard (i.e. slicers, timelines other interaction) A user needs to be able to change variables which updates data table which in turn updates pivot table and dashboardE.g. a variable that affects a...
11. ### Google Datastudio alternative when using Excel

Dear all I'm currently using Google Sheets to manage my stock portfolio. The system is to enter day which is tweaked and analyzed in many ways. To visualize data, current status and that I'm (hopefully) on track I use Google Datastudio. Actually I would like to move from Google Sheets to Excel...
12. ### Dashboard for data on multiple worksheets

I have a file with multiple worksheets. Each worksheet has the same format, and each column shares a lot of the same data. Each worksheet is for a project that my team and I work on. What I would like to do is create a Dashboard for each team member which would show the tasks they are assigned...
13. ### VBA Save PDF file of each sheet from Dashboard

Hi, In my Dashboard sheet I have totals that feed through from each of the client sheets. Next to these totals, in column G, I have check boxes. I would like a saving macro to run if the check box is ticked. So; Sheet1 (Dashboard) Check box ticked - save pdf file of Sheet4 (Cordis) Check box...
14. ### How to save an excel Dashboard as an interactive web page

Dear Excel experts, I made a nice dashboard in excel with graphs (from pivot tables) with slicers. I want to save this excel dashboard as a webpage, while maintaining the functionalities (using the slicer to select things, on which the graph automatically adjusts itself). Saving as a webpage...
15. ### Custom Print Pages VBA

Hi All, I am trying to write VBA code for a CommandButton. I want the button to print in pdf a Dashboard from a tab in my worksheet called "Dashboard". It has 21 pages at the moment but I want to print it as one document and different pages need different scaling/margin settings. Is it...
16. ### Lookup value from another table

I have a Workbook with tabs and each tab contains a table. Each table is the same format (Column A is ColA, Column B is ColB, etc). One of my tabs is a dashboard, where I want to retrieve values from each tab: Dashboard tab Column H will look into table Data-A and return the value of Column H...
17. ### Formule not refreshing

Hey all, i use the following code to pull data from another workbook; =IF(INDEX('P:\000 Dashboard Production\Tabellen nieuw\[Bezetting 2019.xlsx]Planning'!\$A\$6:A69;ROW())=0;"";INDEX('P:\000 Dashboard Production\Tabellen nieuw\[Bezetting 2019.xlsx]Planning'!\$A\$6:A69;ROW())) The data in this...
18. ### Dynamically paste hyperlink to another sheet

Hello, I have a macro that currently pastes text and charts to a Dashboard sheet from several other pre-formatted sheets. The pre-formatted sheets are copied and renamed by another macro, when the user wants to create a new sheet of one of the 5 template types we have in this tool. I would like...
19. ### VBA to expand pivot table

Hi, I have 24 pivots in sheet1 and in sheet2 I have a dashboard which will have the numbers from the Pivot output. I have used GETPIVOTDATA to fetch the data from Pivot to my dashboard Table. I have 5 slicers connected to all the 24 pivots. I have years as data in one of the pivot as columns...
20. ### Copy Worksheet as Data with Charts

Hi all, I have been reading a lot of content here over the years and would like to congratulate the helpful community for the fantastically helpful work all of you have provided here. How, I am posting here for the first time, as I can't find a solution to my problem using the search function...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back