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

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top