![]() It will then create a pie chart with the data applied to it. This includes 2D, 3D, and doughnut pie charts. After that, select the pie chart option that you want to create. At this point, the chart shows data for only the year 2008, the last year for which there are data, but a stimulating play button appears in the lower-left corner of the chart. To create the pie chart, go to the Insert tab in your Excel window, then click on the Pie Chart icon, which is represented as a circular button in the Chart group. For example, in Figure 10-24, we put the year in the play axis. It can be the year, the month, or the date, depending on the granularity you want to look at. In a bubble chart, you can drop a calendar attribute into the play area. We strongly suggest that you look at the chart in the companion workbook and play around with it, because words simply cannot describe the visual experience of looking at it. Moreover, scatter charts have another amazing feature, which we can only try to describe here. The final representation is compact, yet informative. ![]() It will take some time before you find a good way of showing the numbers in a chart, but it is worth spending that time. The Road-650 model has many more products, but it sells less and produces less revenues. It is also interesting to compare the Mountain-200 bubble with the Road-650 bubble. By reading the chart, it is easy to see that the top seller is Mountain-200, the biggest bubble of all, thus producing the most of the revenues. To create this chart, you need to use the sales on the y-axis, the number of products on the x-axis, and the product model name as the detail, and the bubble size reflects the size of profits. A bubble chart shows many related pieces of information in a single visualization.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |