98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Dashboard
Dashboard
Resolved · High Priority · Version 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Autofit column width – Excel (all versions)a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column. |