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:
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:ß