SOLVED: VIDEO: How To Create a Sunburst Chart In Excel

If you want to get a bunch of data that you need to get into peoples heads, you need to convert that data to information.  The best way to accomplish this is with a graphic.  In this video we will show you how to very easily convert the information in the tiered Excel sheet below into a much more meaningful sunburst graphic. Energy Stationary Combustion Mining & Upstream Oil & Gas Production 105253 Public Electricity…

SOLVED: VIDEO: Easy Way To Plot Cities on a Map Using Excel

If you have tried to use Excel’s new(ish) chart to map feature you will find how easy it is to use.  However, it does only supports Countries and Provinces/States, so if you try to INSERT > CHART > MAP with city data you will see: MAP CHART NEEDS GEOGRAPHICAL DATA SUCH AS COUNTRY/REGION, STATE/PROVINCE OR POSTAL CODE. CHECK YOUR DATA AND TRY AGAIN However, there is a very simple way around this problem as shown…