dashboard

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

Hey Guys, Need your assistance and help- So, I'm creating an overview dashboard. My dilemma is that im trying to place an icon indicator up or down arrow key to show whether it meets the requirements example is the attached file here. So if you are looking at CS Quality SCore - if its > 92% a...

Hi All, I need some help with obtaining Pivot Table data. I am unsure about what is the best way to accomplish what I want. I have a Pivot Table that is filtered to display the bottom performers for each class of students. Each class has a different number of bottom performing students. For...

Dear All, I would like to know how can I conditional format this chart: Objective: "Change the color of graph to “Red” or “Green” depending on Achievement %age in cell “B40 to G40” in tab “PDV”. Currently, the graph colors are different (random colors). Change the color of graph to “Red” or...

Hi All, I need some help with the GETPIVOTDATA function and setting up an interactive dashboard. I have a PivotTable that shows the grade percentage for each student in a certain class. On my dashboard, I want to split the students up by class. Unfortunately, I do not know how I should...

Greetings, I want to thank those who nudge me with great information each time I post. I'm piecing together and learning Excel and Access during my spare time and loving it. I'm trying to come up with a Dashboard in Excel and I've already created a little spreadsheet and what I do is run a...

Hi All, I am new here and I was hoping to get help with my problem as I am at the end of my limited powers. I have 2 Excel Workbooks online for clients to look at. One is "parent" WB (dashboard with graphs) the other one is "Data Input" WB (all information for graphs for dashboard are updated...

Hello, I keep getting this error when my macro hits the "saveas" point. I've spent hours trying to figure out what's wrong. Any idea's? Sub FormatTagExpiration() ' ' This macro opens specific workbooks to "clean" them up for processing them into a summary workbook. ' Dim src As Workbook...

I am looking to pull data from a table and have it display on a dashboard and update dynamically

I wonder if it is possible to have similar to a dashboard or menu, where I have a list of sheets to choose from ( it might be as many as 30 ) when I click on the sheet name it takes me to the sheet instead of needing to scroll along to find the sheet I need. The sheets are very low data, a few...

Hello, I have a dashboard made up of slicers and charts connected to several pivots table to drill up and down.. They have the same data source and the "Data" and pivot sheets are hidden. My next aim is to display the data (10 columns) based on the slicer selections at the bottom of the...

I have designed a dashboard for work, one of the sheets (called calculations) contains all of the raw figures and the other sheet I use displays the dashboard. I have the dashboard automatically change the chart depending on the month / specific figure selected (see below). In the above...

Can I get raw data from 2 differences sheet onto a dashboard with only using 1 slicer.

Hello everyone, Before you read this post know that I am not very skilled at all at excel and access. I made this account at work today because my boss wants me to create this tool but I don't have the slightest clue how. I probably am going to sound like an idiot so bare with me here. I...

Hello everyone, Before you read this post know that I am not very skilled at all at excel. I made this account at work today because my boss wants me to create this tool but I don't have the slightest clue how. I probably am going to sound like an idiot so bare with me here. I apologize in...

RE: Conditional Formatting Query Hi All I have a spreadsheet where we are capturing Go live dates for a project, the sheet is called "OTR Sites Dashboard", the "Site Proposed Go Live" column is E, we then have another sheet called "Bank Holidays" and that looks up the sites from the OTR Sites...

Hi all I have created a dashboard which updates based on a dropdown list. I need a macro which will cycle through all of the options in the dropdown list and also export a pdf copy of each updated dashboard. The current excel model takes a considerable time to recalculate after each dropdown...

Hi All I am having an issue with trying to get a formula to work and hope that someone tell point me in the right direction please Worksheets "Supplier Dashboard" Column "A:A" has supplier names Worksheets "Supplier Dashboard" Column "BB:BB" has number values D5 is a drop down box (Qtr1...