In prior versions of Excel, you had the Chart Wizard to help you create charts. That was a great tool and a great help, but Excel 2016 offers you something even better: Recommended Charts tool. Florida driver manual in chinese. This is under the Insert tab on the Ribbon in the Charts group (as pictured above). Creating Sunburst Charts in Microsoft Excel 2016.This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Offic.
Six New Charts Excel 2016
Οι απεικονίσεις γραφημάτων που αντιπροσωπεύουν αναλύσεις δεδομένων είναι πάρα πολύ σημαντικά για όσους ασχολούνται με αυτά. Στο Excel είχαμε αρκετά διαθέσιμα γραφήματα που μπορούσαμε να χρησιμοποιήσουμε για απεικονίσουμε τα δεδομένα μας. Τώρα στο Excel2016 έχουν προστεθεί άλλα νέα έξι γραφήματα τα οποία θα περιγραφούν παρακάτω.
Μπορούμε να επιλέξουμε να εισάγουμε ΓραφήματαΙεραρχίας (Hierarchy Chart)όπως τα ΓραφήματαTreemap ή Sunburst ή να εισάγουμε ΓραφήματαΣτατιστικών (Statistical Charts) όπως Ιστόγραμμα (Histogram) ή ΠλαίσιοκαιWhisker (Box and Whisker).
Πρώτα θα πρέπει να επιλέξουμε την περιοχή δεδομένων που θέλουμε να απεικονίσουμε σε γράφημα και έπειτα να επιλέξουμε το tab Εισαγωγή (Insert) και να εντοπίσουμε την περιοχή της κορδέλας που ονομάζεται Γραφήματα (Charts) όπως εμφανίζεται και στην παρακάτω εικόνα.
Για να μπορέσουμε να δούμε τα έξι νέα Γραφήματα (Chart) που είναι διαθέσιμα στο MicrosoftExcel2016, μπορούμε είτε να επιλέξουμε το κουμπί ΠροτεινόμεναΓραφήματα (Recommended Charts) όπως εμφανίζεται και παρακάτω, είτε να επιλέξουμε το κάτω δεξιό βέλος της περιοχής Γραφήματα (Charts).
By: Koen Verbeeck | Updated: 2015-09-17 | Comments | Related: More >SQL Server 2016
Problem
At the time of writing, SQL Server 2016 preview (CTP 2.2) has been released and it contains a few exciting changes for SQL Server Reporting Services (SSRS). One of the new additions is a new chart type: thesunburst. This tip will give an introduction on how to create a sunburst graph.
Solution
A sunburst graph is a graph type ideal for displaying hierarchical data. It'scalled a sunburst because if you have an unbalanced hierarchy (meaning somebranches stop earlier than others) the chart looks a bit like a sun with rays shootingout:
Here we have a 'ray' shooting out for February, as it is the only month forwhich there is weekly data. In fact a sunburst chart is just a donut chart(which is a pie chart with a hole in the middle), but with multiple layers. Ifslices of a layer have missing data (the missing weeks for all the months exceptFebruary), the graph doesn't show anything for those slices.
As you can see, a sunburst chart is ideal for giving a sense of how the datarelates to a hierarchy and how an outer ring contributes to an inner ring, butit lacks in precision. It's hard to compare slices with each other and you can'tread exact numeric data from it, unless you use labels, annotations or tooltips.A treemap can display hierarchical data as well and because it uses rectangles,it's a bit easier to compare relative sizes with each other. For moreinformation about treemaps in SSRS, check out -How to create a Treemap Graph in Reporting Services 2016.
The Office help page has a nice article on how to create a sunburst chart inExcel 2016: Create a sunburst chart in Office 2016.The sample data of that article is used to make the example above in SSRS.
Sunburst Chart Excel 2016 Excel
Test Data
First of all, we need data for our sunburst chart. TheAdventureWorksDW database contains a greatunbalanced hierarchy: the employee dimension. This dimension is modeled as aparent-child relationship, but with the following query we can get a flattenedhierarchy:
Remember this dimension is a type 2 SCD, so we need to filter on the currentrows. This hierarchy is 5 levels deep, but not every branch of the hierarchygoes that far down:
Every time NULL values start showing up, it's a sign the branch has stoppedat a particular level and this is where the sunburst chart will empty space.
SQL Server 2016 preview
As mentioned earlier, at the time of writing SQL Server 2016 is still in preview (currently CTP 2.2 has been released). This means that the look and feel of Reporting Services and its charts can still change and that functionality might change, disappear orbe added.
Another issue is a new version of the SSDT-BI (the Visual Studio shell for developing business intelligence solutions)has not been released for SQL Server 2016. You can develop BI solutions for SQL Server 2016 preview using SSDT-BI 2013 (which is actually for SQL Server 2014), but it has only SQL Server 2014 features. So how are we going to test now SSRS functionality? Luckily Report Builder has already been updated and included in the SQL Server 2016 CTP 2.2 release, so in this tip we’ll use Report Builder to create the treemap.
In order to use Report Builder, you need to install SSRS 2016 CTP 2.2 (or later), preferably not on your production machine. Then you navigate to Report Manager - typically the URL has the format http://myserver/Reports - where you can launch Report Builder.
Creating a Sunburst Chart in SQL Server 2016 Reporting Services
First create a blank report with Report Builder, add a connection to yourdatabase and add a dataset with the query from the Test Data section ofthis tip. Next add a new chart to the canvas.
The sunburst chart type is listed under the Shape types:
After the chart has been added to the canvas, click on it so the Chart Data window opens up. Add the field EmpCount toValues.
Although you get a preview, if you run the report you end up with an empty chart (nothing is displayed). The chart will only display data once there are category groups defined. So let's put Level1 Name on Category Groups.
When you preview the report, you get the first ring of the sunburst. The data label shows the total number of employees:
Each time we add another level to the category groups, another ring is added to the sunburst.
To add more color to the sunburst, you can add fields to the series groups. Let's add the name of level 2.
This will result in the sunburst being divided by color in slices depending on who is their superior on level 2.
The graph now shows the real strength of sunburst graphs. You can immediately see that a large part of the company have one common executive at level 2, while the (small) remainder is divided under multiple executives. Adding more levelsto series groups has however a counterproductive effect. SSRS takes the levelwith the lowest grain and divides colors amongst that level. If there are a lotof members on that level, you get too many colors. The chart then resembles thecolor wheel of your local paint shop.
Unfortunately in the current CTP release of SQL Server 2016, tooltips aren't working properly. If you define an expression, it only shows in the outer ring. All other rings display by defaultin the field defined in category groups. Download instruments for garageband ipad. This will probably change in the future.
You also have no control over the different slices. When using pie charts, there are a whole bunch of properties you can set to control how slices behave. A very interesting one is pie start angle, where you can set at which 'hour of the clock' the first slice starts.
Outlook 2016 for mac stuck in sending. There are no such properties for the sunburst chart, but again, this might change in the future.
Conclusion
The sunburst graph type is a nice addition to the toolset of the SSRS developer. It shows the dependency of various members in a hierarchy quite well. However, it lacks in displaying accurate information since it's hard to compare individual slices. The sunburstchart type has a few minor issues, but those might be solved in later releasesof SQL Server 2016.
Next Steps
- Try it out yourself!Download and install the SQL Server 2016 preview and follow the steps inthis tip to create your own sunburst chart.
- For more SQL Server 2016, read these otherSQL Server 2016 Tips.
- For more Reporting Services tips:Reporting Services Charts Tips.
Last Updated: 2015-09-17
About the author
Sunburst Chart Excel 2016
View all my tips