## CS代写|数据可视化代写Data visualization代考|Trying to Display Too Much Information

Another common mistake in building effective charts is trying to convey too much information on a single chart, which is a symptom of trying to communicate too many insights to the audience simultaneously.

Consider the case of Keeland Industries, an online company that provides replacement parts for automobiles. It provides both original-equipment manufacturer (OEM) replacement parts and replacement parts made by different manufacturers that are known as aftermarket replacement parts. Because Keeland sells the replacement parts online, it sells parts to customers throughout the United States. For sales tracking and performance measurement purposes, Keeland divides the United States into 12 regions. Keeland’s management team is most interested in comparing the OEM sales across the 12 regions to see which are performing best for OEM sales and in comparing the Aftermarket sales across the 12 regions to see which are performing best for Aftermarket sales.

Figure $3.30$ displays the OEM and Aftermarket sales by region as a clustered column chart. The clustered column chart makes it easy to compare OEM sales to Aftermarket sales in each region. However, if the potential markets for these different types of parts are different in each region, that comparison is not particularly useful.
Figure $3.31$ displays the OEM and Aftermarket sales by region as a stacked column chart. The stacked column chart makes it much easier to compare the total sales in the different regions. Therefore, a stacked column chart would be a good choice if the goal is to compare total sales (OEM plus Aftermarket) among the 12 regions. However, the stated goal of this visualization is to compare the OEM sales across regions separately from the Aftermarket sales. The best visualization to accomplish the stated goal is to use two separate column charts as shown in Figures $3.32$ and $3.33$.

## CS代写|数据可视化代写Data visualization代考|Using Excel Default Settings for Charts

Microsoft Excel allows for the creation of a variety of charts and tables to visualize data. However, a common mistake is to use the default output from Excel without considering changes to the design and format of the visualizations it produces. Excel’s default settings are counter to many of the suggestions covered in this chapter (and the rest of this textbook) for creating good data visualizations. Consider Figure 3.34. This column chart, which was produced using Excel, shows revenues for eight retail store locations in Texas. The company is interested in comparing revenues by location, and specifically in examining the relative performance of the store located in Laredo because this store has recently had a change in management.

Figure $3.34$ suffers from several flaws that prevent it from being an effective data visualization. The data-ink ratio for Figure $3.34$ is low, so we should consider ways of decluttering the figure. Examining Figure $3.34$ shows that the chart uses ink in several ways that are not useful in conveying the data. The gridlines used in this chart are not particularly useful, so they can be removed. We see that Excel automatically titles the chart “Annual Revenue” and uses a legend with “Annual Revenue.” This is redundant information, and at least one of these labels should be removed. The following steps can be uscd to declutter the default chart produccd by Excel, increasc the data-ink ratio, and make the chart more meaningful to the audience.
Step 1. Click anywhere on the chart in the file RetailRevenueChart
Step 2. Click the Chart Elements button $+$
Deselect the check box for Gridlines
Deselect the check box for Legend
Steps 1 and 2 increase the data-ink ratio by decluttering the chart. We can further improve this chart by adding meaningful ink to the chart and making a few other modifications. For example, the revenue values shown in this chart are from the previous year and are in 1000s of dollars. None of this is clear from the chart. To make it easier for the audience to compare the relative amounts of annual revenue by location, we can sort the columns in decreasing order. Finally, because the audience is particularly interested in annual sales at the Laredo location, we can change the color of the column associated with Laredo to draw the audience’s attention to that part of the chart. The following steps create the finished column chart shown in Figure 3.35.

# 数据可视化代考

## CS代写|数据可视化代写Data visualization代考|Using Excel Default Settings for Charts

Microsoft Excel 允许创建各种图表和表格来可视化数据。但是，一个常见的错误是使用 Excel 的默认输出，而不考虑对其生成的可视化的设计和格式进行更改。Excel 的默认设置与本章（以及本教科书的其余部分）中关于创建良好数据可视化的许多建议背道而驰。考虑图 3.34。这个使用 Excel 生成的柱形图显示了德克萨斯州八个零售店位置的收入。该公司有兴趣按地点比较收入，特别是检查位于拉雷多的商店的相对业绩，因为这家商店最近发生了管理层变动。

myassignments-help数学代考价格说明

1、客户需提供物理代考的网址，相关账户，以及课程名称，Textbook等相关资料~客服会根据作业数量和持续时间给您定价~使收费透明，让您清楚的知道您的钱花在什么地方。

2、数学代写一般每篇报价约为600—1000rmb，费用根据持续时间、周作业量、成绩要求有所浮动(持续时间越长约便宜、周作业量越多约贵、成绩要求越高越贵)，报价后价格觉得合适，可以先付一周的款，我们帮你试做，满意后再继续，遇到Fail全额退款。

3、myassignments-help公司所有MATH作业代写服务支持付半款，全款，周付款，周付款一方面方便大家查阅自己的分数，一方面也方便大家资金周转，注意:每周固定周一时先预付下周的定金，不付定金不予继续做。物理代写一次性付清打9.5折。

Math作业代写、数学代写常见问题

myassignments-help擅长领域包含但不是全部: