Treemap is a welcome addition to Excel though it does show up some limitations in the current chart infrastructure. Microsoft explains that Treemap will not appear in the Recommended Chart list unless “empty (blank) cells exist within the hierarchal structure”. You may need to explicitly select Treemap from the list of charts. The above chart could be separated into regions then states. It’s possible to show sub-groups as well. There are nine supplied Treemap variations, most of which include a legend. Perhaps the most interesting new chart is Treemap, because it’s quite different to the look of other Excel charts. The sixth, Pareto, is under the Histogram option. You can find five of them on the Insert Chart ribbon or the All Charts dialog: Treemap, Sunburst, Box & Whisker, Waterfall and Histogram. They are the first truly ‘exciting’ thing to see in Office 2016 (to borrow Microsoft’s overused term). Poor old Excel’s charts are looking tired.Įxcel 2016 changes that with six new chart formats. There’s many interesting and useful charting options available in other software and web services. The biggest complaint about Excel in recent years has been the lack of innovation in charts. Thanks for joining us! You'll get a welcome message in a few moments.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |