What has changed in Excel?
People are used to visualizing the data in pie chart forms as well as comprehensive tables. But sometimes, when you constantly see the same interpretation, you may lose your attention. Therefore, Hot Key Excellence explored a few more interactive alternatives such as doughnuts and waterfalls. Here are the top new ways to show data in Excel.
Regardless of how funny it may sound, you may consider the doughnut chart. These charts have additional white space and refresh the corporate charting circuit. Whereas, typical pie charts lack of visual precision of the column charts. In addition, they usually reduce the data points making them barely visible.
When navigating in Excel, select your data, click insert and then specifically Doughnut chart icon. To edit the chart based on the presentation style, right-click the chart body and go for Format Data Series. Finally, adjust the hole size so that it does not look too skinny.
The waterfall chart helps at visualizing the expenses or tracking the value of a financial portfolio over time and more. It shows how negative and positive values have an impact on the total. Comparing to the regular line or trend charts, waterfall charts show separate losses and gains.
Creating a waterfall chart does not require much effort. First, create an array with two columns containing months and dollar amounts. Select the whole array, Insert and click on Recommended Charts icon. In that area, you will find the Waterfall chart which will appear a bit unformatted. To make it prettier, right-click the Y-axis labels, go to Format Axis and enter 15400 followed by OK. After that, click the Number, select Currency, type 0 in the decimal place and press Enter. The final step is to click on the first column in the chart to make it highlighted and go to Format Data Point, select Series Options and click on Set as the total checkbox. All set!
The Excel sunburst chart looks like a typical pie chart with multiple levels. It shows the relationship between the data by analyzing different hierarchies of data. Moreover, they are able to read the structure of the data set. For instance, the company has four product lines and a spreadsheet keeps track of the sale across different categories. These categories are divided into industries. In the end, you only select the relevant cells and Insert Recommended Charts (in particular, sunburst).
If your goal is to see whether if you achieve your goal or not and how far are you from that, then the thermometer chart is a perfect choice. Pretend to have an array with four cells and the purpose of those numbers is to raise donations for a cause. You have your goal set on the left and collected money on the right. By selecting the cells, go to Insert, then Column Chart and Clustered chart.
On the donations side click Format Data Series, then Secondary Axis in the Series Options. You will see a couple of changes. Then right-click the left axis, go to Format Axis and enter your goal for donations in the Maximum box located in the Axis Options. This is the same procedure for the right axis. Another step is to empty the goal field by clicking the Fill and Line icon on the right side. Then, No fill and set the Border to a black line. Delete the X-axis and right axis labels, tighten the left axis and you are done.
If you are interested in learning how to execute these commands faster, try keySkillset game and test your Excel skills.