Display empty cells, null (#N/A) values, and hidden ...
Change the way that empty cells, null (#N/A) values, and hidden rows and columns are displayed in a chart. Click the chart you want to change. Go to Chart Tools on the Ribbon, then on the Design tab, in the Data group, click Select Data. Click Hidden and Empty Cells.
Create an org chart in PowerPoint by using a template
Learn how to use a template to create an org chart in PowerPoint. You can create, download, and customize a PowerPoint org chart template.
Available chart types in Office - Microsoft Support
The treemap chart can be plotted when empty (blank) cells exist within the hierarchal structure and treemap charts are good for comparing proportions within the hierarchy. There are no chart sub-types for treemap charts.
Display empty cells, null (#N/A) values, and hidden worksheet data …
Change the way that empty cells, null (#N/A) values, and hidden rows and columns are displayed in a chart. Click the chart you want to change. Go to Chart Tools on the Ribbon, then on the Design tab, in the Data group, click Select Data. Click Hidden and Empty Cells.
Add or remove data labels in a chart - Microsoft Support
To quickly identify a data series in a chart, you can add data labels to the data points of the chart. By default, the data labels are linked to values on the worksheet, and they update automatically when changes are made to these values.
Create a sunburst chart in Office - Microsoft Support
Create a treemap chart in Office. Use the sunburst chart, introduced in Office 2016 for Windows to quickly see a hierarchial representation of your data. Sunburst charts are also known as ring charts.
Show or hide a chart legend or data table - Microsoft Support
You can hide or show the legend of a chart. You can also show a data table for a line chart, area chart, column chart, or bar chart.
Save a custom chart as a template - Microsoft Support
To reuse a chart you customized, you can save it as a chart template (*.crtx). Right-click the chart, and select Save as Template. In the File name box, type an appropriate name for the chart template. Click Save.
Update the data in an existing chart - Microsoft Support
Learn how to update the data in an existing chart from its source. Edit a chart in Excel, create a chart from a table, and update a chart source.
Change the data in an existing chart - Microsoft Support
If your PowerPoint presentation contains a chart, you can edit the chart data directly in PowerPoint, whether the chart is embedded in or linked to your presentation. You can also update or refresh the data in a linked chart without having to …
Add or remove series lines, drop lines, high-low lines, or up …
You can add predefined lines or bars to charts in several apps for Office. By adding lines, including series lines, drop lines, high-low lines, and up-down bars, to specific chart can help you analyze the data that is displayed. If you no longer want to display the lines or bars, you can remove them. New to formatting charts in Excel?