dashboard

  1. B

    Need help with dashboarding

    Can someone help me with dashboarding? I've got data where you can see who (Column 'Plant') did something during the month. I need to easily see during the month who did something that month/this year. And I want to easily see/select where it is not going great during the month/year. This data...
  2. D

    Dashboard with Lights

    Hello, I'm trying to create a professional looking Dashboard that a person can look at and know if everything on the document has been filled out. I was thinking of using the stoplight feature, but I cannot figure out how to make it look for words instead. An example would be that on sheet 1...
  3. J

    Maintain icon conditional formatting from list in another sheet

    So I have a list of numbers in sheet_A associated with a list of names, and then I apply the traffic light icon conditional formatting so that they have a relative conditional formatting in the list. Now can I somehow show a value from sheet_A in sheet_B which maintains and shows the icon...
  4. Excelnerd74

    Present 4 combination graphs on 1 page

    Hi there, I joined today. I do have a question, I used to have an add in where I used to work to create dashboards. Time has moved on, plus I now work somewhere else. I am collating some staff figures for my Department lead, and I would like to be able to present to her in a Dashboard sense...
  5. 2

    Pivot Table Help

    I have a data set with a group of data repeated each year. For example, I have data on schools over a 10 year period. Each school has multiple columns of data. The data needs to be compared for each school across the years to identify trends and needs to be compared to other schools in the...
  6. A

    dashboard

    Hello Experts, I have a actual sales data from past 2 years , which includes more than 1000 parts and these parts goes to more than 50 customers. ( few parts are common to all customers & few are customer specific parts) now from last 2 months we observed the increase in schedule quantity for...
  7. N

    Issue with Pivot table slicer connection on Excel dashboard

    Hi guys, I am currently not able to connect the various charts i have created on my dashboard to the same slicer filter I added. For some reason, Only the first Pivot table shows up when I click on 'Report connection. I have tried to fix it with some of the solutions shared on this Thread but...
  8. J

    Dashboard view for validation of true false

    Context... I'm working with a very large file but I will simplify it with the following: I have static data in columns a through d (static datal and look up formulas in columns H through H fetching data from a report (report data). The static and report data should reconcile one for one. Columns...
  9. S

    Dashboard Bookmark and Dax Help

    Hi I am building a dashboard for survey data and for reasons I am not quite sure I am running into a couple of problems. I have five questions that I want to focus on. My dashboard looks like so: 1) I wrapped the text box at the top with a blank box that i removed the borders. When I...
  10. T

    Dashboard issue

    I'm creating a dashboard on a separate sheet with the following dataset. I need the top 5 Totals and their corresponding projects. I've been using =INDEX(Sheet1!$A$2:$A$9,LARGE(IF(LARGE(Sheet1!$L$2:$L$9,1)=Sheet1!$L$2:$L$9,ROW(Sheet1!$L$2:$L$9)+1),1)) and then changing the row and LARGE...
  11. C

    Summarizing Income Statement Data

    Hi, I have income statements from three different companies. My goal is to make a dashboard or snapshot page that shows one of the line items (ie. Revenue) over a specific period which you type in. In the example below, I want a line chart that displays the revenue of Google between the periods...
  12. F

    Formulas for Dashboard # 2

    I’m in the process of making a dashboard.. I would like to calculate the total cases by Year and by Customer Name I will use combo boxes for both. I’m having trouble with the formulas because of the “ALL” Years and “ALL” Customers. What Formulas would go in Columns J and M? Also would like...
  13. F

    Formulas for Dashboard to calculate "ALL"

    I'm using excel 365 I’m in the process of making a dashboard.. I would like to calculate the total cases by Year and by Customer Name I will use combo boxes for both, or maybe radio buttons for the year. I’m having trouble with the formulas because of the “ALL” Years and “ALL” Customers...
  14. X

    Dashboard Objects are Randomly Resizing on a Data Refresh!

    Hey everyone, I don't use Excel a lot, so I am quite proud with what I have come up with. Wish I could share it but it has all my financial data and crypto holdings to create a dashboard. Power queries, just trying to solve a different issue at the moment with VBA, the lot! Besides the...
  15. B

    Rank data displaying only top 3 products

    Hi, I need some help with a spreadsheet that I cannot change the source data (raw data), which is extracted from a report. Basically, I need to identify the products with highest satisfaction rating among a plethora of products, in a single column with data that goes from smartphones, tablets...
  16. A

    Gauge Chart

    I'm trying to create a gauge chart in which the colors of the gauge are equal 45 of the 180 half circle as picture below but the values for each section are much different. See the chart to see which values would fit into each section of the chart. Is this even possible? Any help would be much...
  17. L

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

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

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

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

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top