Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

dashboard

ResolvedVersion 2016

Lisa has attended:
Excel Advanced course

Dashboard

Dear STL,

I have a data table that I want to use to create a dashboard showing how much new space has been built in each year ( a chart), and then be able to slice the data by location, building and developer.

We were shown how to do this but I cannot get it to work.

Please can someone help?! I will gladly send the spreadsheet.

Kind regards,
Lisa Dean

RE: Dashboard

Hi Lisa,

Thank you for the forum question.

What is not working.

Slicers can filter any number of PivotTables, but only if the PivotTables are created from the same Pivot cache (from the same source). If the data come from multiple sources you can create a data model (create relationships between the sources), but this can only be done if it is related date.

You can send me the file:

forum@stl-training.co.uk


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Dashboard

Hi Lisa,

I do not know if you have tried sending the file.

We have an issue with the email address I gave you.

Please send the file to info@microsofttraining.net



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Dashboard

Hi Lisa,

I have the file and I am not sure what you mean by it is not working. When I click the options on the slicers it filter the PivotTable and the Pivot Chart.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Dashboard

Hi Jens,

In the dashboard tab, it wasn't showing what I wanted it to, meaning by town, each year the total square feet etc. I managed yesterday to get it to work properly (i.e.by town). I had to insert a column which I called City. I was then able to get the data out of the table with the pivot table and then insert the slicers on the dashboard, which showed what I wanted eventually. I will send the updated file to you so you can see what I mean.

Thank you for taking the time to respond and try to help. I think it will just take some time for me to get used to using it. One thing I did want to ask was how do I put the conditional formatting in - like top 10 developers in a town by total square feet?

Thanks again,
Lisa

RE: Dashboard

Hi Lisa,

I have sent you an email.

Please let me know if you need more assistants.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Excel tip:

Auto-insert the current time

In Microsoft Excel, to enter the current time into a cell, hold CTRL+SHIFT and press SEMICOLON.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.