excel dashboard

I have prepared a dashboard which contains about 50+ shapes and 25+ images linked with formulas to derive values from other sheets in the same file. I have noticed that overall excel working has become very slow, like scrolling, and moving from one cell to another cell, typing any value and...

Overview: I am trying to create a dashboard wherein the user can provide information to copy from the given file name, sheet name and range/chart name. Also, the ability to paste the Range/Charts as Image or Table or Chart Object can be selected from the dashboard itself and paste them into the...

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

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

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

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

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

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