How to add deviations into your chart

Sometimes you can give your charts a more impressive view by showing deviations of some real process from its expected flow.

Creating picture charts

Excel easily incorporates a pattern, texture, or graphic file for elements of your chart (see more about filling options in Microsoft). E.g., you can create a funny burger sales chart for your colleagues or a collected revenue chart:

How to change default chart

When Excel is installed, the default chart is a 2-D Column chart, but you can easily change the default chart type.

Show chart data in hidden cells

Excel allows you to create charts and diagrams from different data sets, even those that contain hidden or empty cells. However, sometimes you may see unexpected results. For example, if there are hidden cells in the chart data, by default, Excel ignores such data and doesn't display the corresponding chart elements. You can easily force Excel to handle hidden data.

Speedometer chart

A speedometer, dial, or gauge chart displays a single value (usually displayed as an arrow) on a colored or sectored dial. The speedometer dial can be a half or a whole circle (the simplest option) or a sector located symmetrically vertically:

Preventing objects from being printed or why objects aren't printing

Using the standard Excel tools, you can prevent access to the workbook or protect it from editing. Protection of a sheet from editing does not forbid printing, for example, to a PDF file.

How to use progress pie charts for numbering in PowerPoint

There are different ways to create a numbered list in PowerPoint, but you can always create something creative and modern. This tip is about one of the ways to create a numbering using modern progress circle pie charts.

Waterfall chart

The waterfall chart, also known as the cascade chart or bridge chart, shows how each column, whether positive or negative, relates to other columns and how it affects the overall result. In other words, a waterfall chart reflects the change in value under various factors, such as time.

How to create a Scrolling chart

The Scroll chart shows data for a long period in small scrollable time chunks. It makes easier to analyze data over a sufficiently long period in Microsoft Excel, Word or PowerPoint.
The Scroll chart displays some contiguous range of data from a large dataset. Using the provided Control tools, it is possible to add a scroll bar to the chart area and view the desired data range:

How to create two vertical axes on the same side

If you need to display two different data series for the one- or compatible-time ranges that have different value scales, you can add the secondary vertical axis:ß