Mr Data Business School | Mr Data Consulting | Mr Data E-Learning | XADAT.NL

Top 10 Beste Dashboard Maken In Excel 2018 Zelf dashboard maken voorbeeld dashboard

Bekijk onze 10 beste dashboards in Excel, SAP BI, MS Power BI. Als u wilt een aanzienlijke hoeveelheid data-analyse weer te geven in een Microsoft Excel-werkblad , overwegen de oprichting van een dashboard . Een Excel dashboard bevat meestal meerdere grafieken en kleine reeksen cijfers uit externe of andere interne werkblad plaatsen en weergegeven op een enkele pagina .

Dit is handig voor presentatie doeleinden en stelt u in staat om onmiddellijk de analyse zien zonder over te schakelen pagina’s . Het opzetten van een dashboard is een uniek proces voor elk project , maar je moet bepaalde functies en commando’s die van toepassing zijn op alle dashboards om te beginnen weten . Instructies


Open een Excel- werkmap met gegevens die u wilt bewerken . Maak een nieuw werkblad , ingevoegd op de voorzijde van de werkmap , en noemen het ‘ Dashboard ‘.

Klik op ” File ” en vervolgens ” Opties”. Klik op ” Lint aanpassen . ” Vink het vakje naast ” Developer ” en klik op “OK . ” Dit maakt uw formulier controle. Formulieren kunnen een essentieel onderdeel in een Excel dashboard zijn.

Insert formulier items door te klikken op “Ontwikkelaar “, ” Insert ” en het selecteren van een vorm optie . Met formulieren , zoals een keuzelijst , kunt u ” Format Control” en kies een output cel . Die cel , in het geval van een keuzelijst , zal een getal dat de geselecteerde optie te tonen . Voor een keuzelijst weergeven van de dagen van de week , bijvoorbeeld , de output cel ( verborgen ) zal een waarde tussen ” 1 ” en bevat ” 7 . ” Dit nummer kan vervolgens worden gebruikt door een grafiek of macro om gegevens alleen voor die dag weer te geven .

2D Area Dashboard Maken In Excel niet mogelijk  

cartogram via Payton Chung

2D area types of data visualisation are usually geospatial, meaning that they relate to the relative position of things on the earth’s surface.

  1. Cartogram: A cartogram distorts the geometry or space of a map to convey the information of an alternative variable, such as population or travel time. The two main types are area and distance cartograms.


  1. choroplethChoropleth: A choropleth is a map with areas patterned or shaded to represent the measurement of a statistical variable, such as most visited website per country or population density by state.


  1. dot distribution map via Eric Fischer

    Dot Distribution Map: A dot distribution or dot density map uses a dot symbol to show the presence of a feature on a map, relying on visual scatter to show spatial pattern.



Temporal visualisations are similar to one-dimensional linear visualisations, but differ because they have a start and finish time and items that may overlap each other.

Connected Scatter Plot Dashboard Maken In Excel niet mogelijk !  

connected scatter plot

  1. Connected Scatter Plot: A connected scatter plot is a scatter plot, a plot that displays values of two variables for a set of data, with an added line that connects the data series.


  1. polar area diagramPolar Area Diagram: A polar area diagram is similar to a traditional pie chart, but sectors differ in how far they extend from the center of the circle rather than by the size of their angles.


  1. time series via Eric Fi

    Time Series Dashboard Maken In Excel niet mogelijk  

  2. Time Series: A time series is a sequence of data points typically consisting of successive measurements made over a time interval, such as the number of website visits over a period of several months.



Multidimensional data elements are those with two or more dimensions. This category is home to many of the most common types of data visualisation.

Ple Chart Dashboard Maken In Excel 2018 niet mogelijk !

pie chart

7. Pie Chart: A pie or circle chart is divided into sectors to illustrate numerical proportion; the arc length and angle of each sector is proportional to the quantity it represents.

Histogram Dashboard Maken In Excel niet mogelijk ! 


8. Histogram: A histogram is a data visualisation that uses rectangles with heights proportional to the count and widths equal to the “bin size” or range of small intervals.

Scatter Plot Dashboard Maken In Excel niet mogelijk  !

scatter plot

9. Scatter Plot: A scatter plot displays values for two variables for a set of data as a collection of points.



Hierarchical data sets are orderings of groups in which larger groups encompass sets of smaller groups.

dendrogram Phylogeny Figures

10. Dendrogram: A dendrogram is a tree diagram used to illustrate an arrangement of clusters produced by hierarchical clustering.




ring chart via

11. Ring Chart: A ring or sunburst chart is a multilevel pie chart that visualises hierarchical data with concentric circles.





tree chart Phylogeny Figures

12. Tree Diagram: A tree diagram or tree structure represents the hierarchical nature of a structure in graph form. It can be visually represented from top to bottom or left to right.



Network data visualisations show how data sets are related to one another within a network.

alluvial diagram via


13. Alluvial Diagram: An alluvial diagram is a type of flow diagram that represents changes in network structure over time.



node link diagram14. Node-Link Diagram: A node-link diagram represents nodes as dots and links as line segments to show how a data set is connected.


matrix via

15. Matrix: A matrix chart or diagram shows the relationship between two, three, or four groups of information and gives information about said relationship.



As you can see, there is a plethora of options when it comes to data visualisation, and these common types are only the tip of the iceberg.


Chart via Digital Inspiration Chart via Digital Inspiration

Alternatieve Dashboard Maken In Excel 2018

Do you want to learn more about data visualization theory and history? Do you want to be inspired by examples of awe-inspiring visualizations? Do you want to be able to create more effective visualizations? Or are you interested in absorbing every bit of information from authorities on data visualization? These are all great topics and knowing more about the topic will improve your use of Tableau. As a part of our Data Visualization Field Guide, here is a list of books we have read and found extremely useful over the last few years. This is far from a definitive list, of course—there are many many more.

An earlier version of this article was written on the Tableau Blog by Andy Cotgreave.

Alternatieven Dashboard Maken In Excel: 1. “Information Dashboard Design: Displaying Data for At-a-glance Monitoring” by Stephen Few


Information Dashboard Design - Displaying Data for At-a-glance Monitoring by Stephen Few
Author: Stephen Few
Website: Perceptual Edge | AmazonThis is a fantastic resource packed full of examples of good and bad dashboards. In explaining how to create great dashboards, Stephen Few also gives a great introduction to the principles of the theory of data visualization and design. We would also recommend any of Stephen Few’s other books, but this one is the most accessible.

This book focuses less on data visualization itself and more on leveraging visualization techniques to your advantage in order to efficiently and critically monitor data at a glance. Dashboards are a common way to keep track of multiple sets of data, and Few’s goal is to help make sure dashboards aren’t unwieldy and inefficient, as they often can be. In this book, he points out common mistakes with dashboard design, as well as best practices to avoid falling into those traps.

Alternatieven Dashboard Maken In Excel 2018: 2. “Beautiful Visualization, Looking at Data Through the Eyes of Experts by Julie Steele, Noah Iliinsky”


Beautiful Visualization, Looking at Data Through the Eyes of Experts by Julie Steele, Noah Iliinsky
Authors: Julie Steele, Noah Iliinsky
Website: O’Reilly Media | AmazonSteele and Iliinsky’s book is a look into the thought process and design behind real-world examples of data visualization projects. 24 experts weigh in on their methods, approach, and perspectives in designing data visualization for their respective fields. “Beautiful Visualization” explores storytelling with data, communicating through visual indicators such as color, and research methods to put it all together.

This book describes the design and development of some well-known visualizations. It’s a great way to learn how others approach visual design. A particular insight is that every single author points out that collecting and cleaning their data is the hardest part of any project. It is heartening to know that this is a pain point for even the best analysts!

Alternatieven Dashboard Maken In Excel: 3. “The Accidental Analyst: Show Your Data Who’s Boss” by Eileen and Stephen McDaniel


The Accidental Analyst Show Your Data Who’s Boss by Eileen and Stephen McDaniel
Authors: Eileen McDaniel, Stephen McDaniel
Website: Freakalytics
Purchase: AmazonThis book is about what to do when you find yourself suddenly thrust into the world of analytics projects, even when you weren’t trained as an analyst. Lots of business users find themselves in this position every day. We have access to data, but maybe our background is in sales, HR, editorial, or operations. This book provides a great template for breaking down any analytics project into distinct segments and delivering something successful and effective.

Whether you landed a new job as a data analyst or had the responsibility plopped on you unexpectedly, this book is great for anyone looking to start digging into data for results. “The Accidental Analyst” provides a step-by-step guide on how to decide what questions you want answered, collect the data, organize the information, display it through visual graphics, and communicate the results.

Alternatieven Dashboard Maken In Excel: 4. “The Functional Art” by Alberto Cairo


The Functional Art by Alberto Cairo
Author: Alberto Cairo
Website: The Functional ArtAlberto Cairo is a data journalist and teaches information graphics and visualization. What is great about this book is that it explains how important it is to stick as close to best-practices as possible but also ensure that your work is beautiful in order to engage the end user.

“Functional art” as a concept is something that serves a purpose while still retaining aesthetic qualities to be appealing and captivating. Cairo argues that this is the goal with data visualization as a whole. In this book, Cairo reviews the aesthetic qualities of data visualization and how to create good-looking pieces while still keeping within industry best practices. He focuses on using color and design to enhance the aesthetic and taking advantage of our brains’ quirks when perceiving and remembering information.

Alternatieven Dashboard Maken In Excel: 5. “The Visual Display of Quantitative Information” by Edward R.Tufte


The Visual Display of Quantitative Information by Edward R.Tufte
Author: Edward R. Tufte
Website: Edward Tufte | AmazonWhile Edward Tufte’s book was first published in 1983 and is beginning to show age, it covers the theory and design of data graphics and is illustrated with some of the best and worst examples. Now over 30 years old, it is still a great introduction to some timeless design theories and provides a historical context for data visualization. The book includes 250 illustrations of data visualization examples of statistical graphics along with detailed breakdown analysis.

Alternatieven Dashboard Maken In Excel: 6. “Cartographies of Time: A History of the Timeline” by Daniel Rosenberg, Anthony Grafton


The Visual Display of Quantitative Information by Edward R.Tufte
Authors: Daniel Rosenberg, Anthony Grafton
Website: AmazonIf you want to read up on the history of data visualization, this is a great book. It focuses on the development of visually representing time, which has been a significant endeavor. It is fascinating and reveals that the challenges we face today in data visualization are similar to those faced hundreds of years ago.

The study of data visualization may be more of a modern endeavor, but the challenges of representing information in visually accessible ways aren’t so different across history. From dashboards to ancient maps, we’ve been trying to display time-specific data for generations. “Cartographies of Time” presents a comprehensive account of western civilization’s attempts at visual timelines through the ages. The book covers graphic representations of time in Europe and North America for almost 600 years, complete with illustrations.

Alternatieven Dashboard Maken In Excel: 7. “Information Graphics” by Sandra Rendgen, Julius Wiedemann


Information Graphics by Sandra Rendgen, Julius Wiedemann
Authors: Sandra Rendgen, Julius Wiedemann
Website: AmazonThis is a huge coffee table book. It has over 400 examples of information graphics from around the world, covering data visualization in journalism, government, education, business, and more. There are also some introductory essays on data visualization history and theory and data journalism.

“Information Graphics” fulfills the role of an almanac in data visualization. The first half features essays on historical context and practice. In the second half of the book, over 200 projects and 400 examples of information graphics from around the world in a variety of disciplines are presented, divided into chapters by location, time, category, and hierarchy.

Alternatieven Dashboard Maken In Excel: 8. “Visual Thinking for Design” by Colin Ware


Visual Thinking for Design by Colin Ware
Author: Colin Ware
Website: Data Visualization Research Lab | AmazonIf you are interested in the science behind data visualization, this book is amazing. It’s a great introduction to design and cognitive psychology. An understanding of this will make you a better visualization designer.

Tthe his book goes into the science and psychology behind design and how you can apply that to data visualization in order to communicate your message more effectively. It presents design as more of a tool, using specific techniques to take advantage of the brain’s process of perception and thinking. It includes hundreds of examples in text as well as visual full-color diagrams.

Alternatieven Dashboard Maken In Excel: 9. “Storytelling With Data: A Data Visualization Guide for Business Professionals” by Cole Nussbaumer Knaflic


Storytelling With Data - A Data Visualization Guide for Business Professionals by Cole Nussbaumer Knaflic
Author: Cole Nussbaumer Knaflic
Website: Storytelling With DataWhile a lot of data visualization books focus on the theory of the subject or the nitty-gritty how-to with using graphics in practice, this book focuses on the WHY: why we use visualization with data. Data itself is a tool and it’s up to us to craft the story with it. Much as writers strive to “show, don’t tell” with their text, “Storytelling With Data” emphasizes using visuals to convey the meaning of the data rather than hoping that the data will speak for itself. The book touches on honing the message of your data by choosing the right type of visual or graph, directing the reader’s attention, and how to effectively communicate using data.

Alternatieven Dashboard Maken In Excel: 10. “Knowledge is Beautiful” by David McCandless


Knowledge is Beautiful by David McCandless
Author: David McCandless
Website: Information Is BeautifulWritten by the same author as the data visualization blog Information is Beautiful, “Knowledge is Beautiful” uses visuals to reveal the world. The book features infographics to present complex information, showing connections and relationships in visual displays. The book traverses data from art to science, from health to popular media, to show patterns and connections in our lives. From charting popular dog breeds to mapping out the exact relationships of the Middle East, this book will satisfy your curiosity itch.

Alternatieven Dashboard Maken In Excel: 11. “Visualize This: The Flowing Data Guide to Design, Visualization, and Statistics” by Nathan Yau


Visualize This - The Flowing Data Guide to Design, Visualization, and Statistics by Nathan Yau
Author: Nathan Yau
Website: Flowing Data | AmazonIn this book, Nathan Yau provides practical tips and step-by-step tutorials to formulate data to tell a story. The book focuses mostly on statistical data with technical references and putting visualization into form through programming. “Visualize This” also features tools and software recommendations to design graphics for both the web and print, along with code examples for web programming like Python and JavaScript.

Alternatieven Dashboard Maken In Excel: 12. “The Big Book of Dashboards” by Steve Wexler, Jeffrey Shaffer, and Andy Cotgreave


The Big Book of Dashboards by Steve Wexler, Jeffrey Shaffer, and Andy Cotgreave
Authors: Steve Wexler, Jeffrey Shaffer, and Andy Cotgreave
Website: Tableau | AmazonIf you need to look at a ton of dashboards for inspiration, look no further. “The Big Book of Dashboards” covers all sorts of dashboards for various industries and departments, using examples from healthcare, marketing, finance, customer service, sports, and others.

Real-world applications are the highlight here, covering the necessity of making sure your data is presentable whether you’re at your computer, presenting in a conference room, or on mobile on-the-go. As we saw with “Information Dashboard Design,” designing a dashboard is nearly as important as the data itself and “The Big Book of Dashboards” addresses practical and psychological factors you may run into before they even come up.


Print Friendly, PDF & Email
User Avatar