excel dashboard

  1. S

    Excel Dashboard

    Hi Guys, I am doomed, Please help me I need your help to create an interactive Dashboard, I have a data divided is Categories and sub categories. Complete data is divided in 6 categories, Which further are divided,1) Location wise, Further divided as 2) Manager wise and so on it end at...
  2. K

    My Data Lables are being deleted when I refresh my dashboard

    I'm building a dashboard in Excel 2016 and I just added new data to my data source/table connected to my pivot tables/dashboard. When I go to Pivot Chart Tool, Analyze Tab, Refresh menu item and select 'Refresh' when I'm on my Dashboard sheet, the data labels on one of the pivot charts on the...
  3. F

    Pivot table and graphs in Excel Dashboard

    Hi everyone, I need to get some fancy statistic graphs out of my excel dashboard Please see Tabs Dashboard and OG Dashboard in the excel dashboard i have attached. For both, I am trying to get reporting over time and success against iTDD, rTDD and TDD (initial Target Delivery Date columns AF...
  4. M

    Creating management information dashboards using MS Office

    I have been tasked with creating a dashboard for quarterly board meetings which will include a large number of performance measures and possibly some graphs (either standard excel or sparklines). I created a template for the dashboard in publisher to begin with and tried to copy in the...
  5. P

    Creating My First Excel Dashboard

    I am an intermediate user of Excel 2010 on Windows 7. I'm very comfortable with vlookups, pivot tables and the macro recorder. I'm interested in creating a dynamic excel dashboard with various metrics from different segments of my company that I can present to upper level managers as an...
  6. S

    How to create simple Excel Dashboard (for 10 year daily data)

    Hello everyone, I have 10 years worth of daily data in my excel work book (linked). I would like to create a dashboard with different metrics (Year to date sales, month to date sales, Year to date costs, Month to date costs, Cost over 5 years, 10 years etc - all the data i have is by day for the...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top