dashboards

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

Hello, I am trying to create a slicer-controlled excel line chart. Where you can select one series or more within the dataset to display on a line chart. I'm able to create a pivot table and even a slicer but I'm having difficulty trying to put everything together. Does anyone have any...

Good night, I started interning in an office where my boss asked me the following: "I'm going pass to you the sales KPIs, for you automate the dashboards generation" From what I understand ... the office uses a website to generate various reports in "Excel Binary Sheets". My boss takes...

Hi Mr. Excel, I have a slicer containing a list of ZIP codes (string), whose value will ultimately be used to extract values from another tab in a worksheet dashboard. How can I simply obtain the value from my selection in a slicer and have that populate a cell for further calculations...

I have the code below which works fine, however I would rather change the sheet references in the code to the actual sheet numbers ie sheet20.select instead of Sheets("132627 Liverpool Lime Street").Select when I try this it crashes thanks Sub LNW_N_SLIDES() ' ' Macro3 Macro ' '...

Good Day I am using a spreadsheet with some tabs that are published as web pages so that we can display them on TV`s as dashboards. In one dashboard we have some targets, I am using the data bars from conditional formatting to gradually color in the cell as we progress. It works great however...

I'm struggling to do a few things with regards to developing actionable insights and presenting in an easy to use dashboard for a wide user group. The situation is as follows; I want to Create a hierarchy dashboard across a number of kpis. I.,e start at the president's view of the average...

Hello, I stand before a task to create a dashboard showing several metrics derived from a single large (expanding 100s rows x 300 fixed collums of data) table. I do have an idea which metrics I need to track, and how to individually get them from the data, but I struggle with defining a...

Hi all I am very new to Power BI and I have been asked to put together a way of reporting that the company can use to solve a variety of problems. I have power BI available to me and with the AD integration, I think it will be the perfect tool. I have already put together some dashboards but i...

I have thousands of rows of data and near 100 workers. I need dynamic dashboards like the one below with subtotals for each item category. I've accomplished linking Power Pivot to the SQL Database and creating a linked table in Excel. What is the best way to create dashboards that will...

I’m doing some research for an blog post and wanted to get some input on Excel dashboard creation... more specifically not the execution of the creation but on the planning and development of it. This would fit the scenario where someone on the leadership team says “Let’s put together a...

Hi, I am working on a dashboard where I am creating drop down dependent charts. For this I have used camera tool to display the picture of graphs (created in separate sheets) selected in the drop down and I am using CHOOSE function to decide the order. The problem is all my graphs are not...

At the moment I am having a huge problem trying to figure something out and I feel it is going to be either a PowerPivot and slice job but can’t figure out how to get the chart to show on the results in the dashboard. I have a load of data that has come from different cities and venues in...

Hi Team, I have been asked to develop a visual display of metrics from data in a weekly status report. We have a ongoing list of high priority items that each have their respective updates and due date. I need to create a "dashboard" possibly... that keeps track of these due dates and provides...

Hello. I am developing a .XLSM dashboard for a company in my PC (I'm a freelancer). I finished the dashboard and I've seen it running in different PCs, even in Excel 2011 (Mac). But when the administrator of the server put the file in a server location, open it (remotely) and try to interact...

I have a program that creates a dashboard for each saleman in the organization. I use the following code to MOVE the sheet then copy and paste the data. It works great until the 11th salesman, then it quits. The sheet I am copying has 12 charts, so after 10 copies the workbook has 120 charts...

I have written a few Dashboards and want to remove the 'extra' excel pieces. Have remove the Ribbon, Formula Bar, Headings, Message Bar and Gridlines - but these seem to only be removed on my computer. Can anyone guide me on how to completely remove all the excel bits, including top and bottom...