dashboard

Hi everyone, My Excel skills are pretty basic, as I have not had the need to do more than the basics. However, my manager is asking me to provide more robust financial reports, so I would like to try building dashboard. The information I need to include in my data: - Cost center number -...

Hi everyone! New to the forum, and in need of some help as I start my journey into developing user friendly Dashboards. Im currently working on a simple Wellness tracker dashboard. It uses a scroll bar (0 to 3) and is linked to a cell which then displaces the data in a radar chart, comparing...

Hi all Apologies if there were similar post, if so can you please link me to them. I have a single excel sheet downlaoded from a SharePoint list that gets updated daily. It has deadlines, multiple goal deadlines, multiple statuses, financial information. From this one datasource i want to...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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