New Microsoft Excel Data Visualization Features That Experts Are Excited 关于
There is no denying how critical Microsoft Excel is for day-to-day data processing and visualizations across organizations. 仍然, many users are not as familiar with the complete functionality of this handy tool as they could be. Today’s users say they have a fairly good knowledge of Excel and yet Microsoft adds new features each year to make it even more useful. Most companies simply don’t have a decent Excel training program to keep their employees up-to-date on the latest new spreadsheet features.
You’ll be happy to know that Excel opens in your web browser just like Word, OneNote, 演示文稿, and PDF documents – making it a breeze for you to work with your data in the cloud.
新添加的Excel图表非常方便. 知道如何以及何时使用它们是很有价值的. This guide will walk you through three of the best to be released this year.
Businesses and organizations always seek to understand their finances better so that they can make their revenue projections more effective. It is critical for them to assess how profits and losses play out at different financial periods. One way to quickly understand and communicate these sets of financial data is through the visualization of financial statements. 这就是瀑布式Excel图表的由来.
瀑布图 allow you to quickly illustrate the line items available in your financial data in a manner that provides a clear picture of how each item impacts your bottom line. They help make it easier to understand the cumulative effect of positive and/or negative values that are sequentially introduced.
You could use a Waterfall chart to illustrate how the negative and positive values in your data cumulatively affect the totals or final value such as net income, 例如.
正常情况下, the outlays or losses that occur throughout the business period should appear as negative integers, while profits or gains are stipulated as positive figures in the Waterfall chart.
Here are some revenue data from the Seattle Art Museum that we will use in our illustration:
To create a Waterfall chart, select your data and head to the ‘插入的 选项卡上的Excel ribbon. From there, navigate to the Charts section and click the Waterfall icon.
一旦你这样做了, Excel为您插入瀑布图表, 与您选择的数据集中的所有值.
Suppose we select the positive values above (first data set); Excel will automatically detect that these are all positive values and color them green as follows:
Notice however that Excel does not identify the last value (Total Operating Revenue) as a total; that’s why it has calibrated it with the same green color.
To resolve that issue, double-click on that total and check the box marked “Set as Total” in the 格式的数据点 窗格中出现.
您将看到这个操作会立即更新图表, 将总值的颜色从绿色更改为灰色, reflecting that all the other values colored green actually accrue to that total.
If we follow the same procedure for the Total Operating Expense (second set of data), bet9官网APP最终的瀑布图是这样的:
treemap are great for showing relationships between sets of data. They use colors to create a contrast between the data sets so that you can capture the information on a Treemap at a glance. Let’s use these ticket sales data from the Seattle Art Museum to illustrate what we’re saying:
如你所见, all the ticket sales have been divided into either online or onsite subcategories and the many different classifications of ticket types. By so doing, we are indicating to Excel how we want to organize our chart.
要创建树图图, bet9官网APP首先要选择整个数据, 然后转到Excel ribbon上的“插入”标签, 并导航到层次结构地图符号. Click the symbol to automatically insert a Treemap chart showing different relationships between online and onsite ticket sales broken down by ticket type.
Map Charts help you draw comparisons of values and show how categories compare across different geographical regions. This is to say you may use map charts only when your data have geographical regions included.
映射表, 例如, would help us visualize the geographical distribution of revenue from the ticket sales above.
To create a Map chart, we would select our data, tap the Insert button and click the map symbol.
This automatically inserts a chloroplast chart with the selected data geographically distributed in it. We can further customize the chart by double-clicking the legend and using the options on the 格式传奇条目 menu.
Graphical representation can be quite helpful when it comes to making comparisons of various sets of data or when you want to pinpoint a trend at a glance. 充分了解这些图表, you have even more tools in your arsenal to take on any data analysis project.