dashboard

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

I have an excel Dashboard. I receive info once per week with 3 columns. they are not in the same order as my columns in the dashboard. I want to do a match and then sort so they match the column info on the dashboard. How can I do that?

Hi all, Here's my scenario. We have sales people who travel everywhere and sometimes VPN connectivity is limited. In our business system, we have a dashboard of their sales data that they want to copy into Excel to use while they travel. The spreadsheet needs to have formulas to calculate...

Hi Everyone, I have this macro that resets the fonts on every sheet to black it works great but I've just realised I don't want it to change the Dashboard sheets, Is there a way to edit it (or start again if you have better ideas) so that it runs on all sheets unless they contain the word...