Present your data in a bubble chart. A bubble chart is a variation of a scatter chart in which the data points (data points: Individual values plotted in a chart and represented by bars, columns, lines, pie or doughnut slices, dots, and various other shapes called data markers. Data markers of the same color constitute a data series.) are replaced with bubbles, and an additional dimension of the data is represented in the size of the bubbles. Just like a scatter chart, a bubble chart does not use a category axis — both horizontal and vertical axes are value axes. In addition to the x values and y values that are plotted in a scatter chart, a bubble chart plots x values, y values, and z (size) values. In this article Learn more about plotting data in a bubble chart You can use a bubble chart instead of a scatter chart if your data has three data series that each contain a set of values. Bubble charts are often used to present financial data.
Consider using a bubble chart when your data includes the following: Top of Page. Interactive Dashboards using PowerPoint and Excel. Business Intelligence with Style and Functionality By Glenna Shaw, PowerPoint MVP What are interactive dashboards, and how can you use dashboards to communicate important information to your audience? This article discusses how to design and use interactive dashboards and provides links to sample files and presentations. In this article Introduction to Dashboards Business Intelligence is a hot commodity in today’s world and dashboards are the most frequently used method of providing that information. So what exactly is a dashboard?
SharePoint and Excel are the most frequently used Microsoft mediums for creating dashboards (see the Microsoft Help Article: Introduction to Business Intelligence Features). When creating any dashboard, the first rule of thumb should be that the data is the star. Top of Page Dashboard Background The first thing you’ll want to do is create your background for housing your dashboard elements. Dashboard Elements Interactive Dashboards Sharing Your Dashboard Conclusion. SkilledUp - Find the best online courses, tutorials and educational resources for free.
More Business Insights with Better Excel Charts and Dashboards The Excel Charts Blog. SpreadsheetZONE - Free Excel Template Repository.