Creating a Gantt chart

A Gantt chart is a horizontal bar chart often used in project management applications like Microsoft Project. In the Gantt chart, the horizontal axis represents the total time span of the project, and each bar represents a project task: the left edge indicates the beginning moment of the activity, and the right edge indicates the estimated ending moment. The viewer can quickly see the duration of each task and identify overlapping tasks.

5 Excel features to create data-dependent visualizations

There are several useful features in Excel that can help to create your charts, which automatically change visual appearance depending on data.

Creating automatically extended plot ranges

If you often need to adjust your data ranges so that your charts plot an updated data range, you may be interested in a trick that forces Excel to update the chart's data range whenever you add new data to your spreadsheet.

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 customize your local Excel chart settings

The default installation of Excel has reasonable presets for chart types and colors, but you can change those defaults according to your own preferences.

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 make Mirror chart in Excel

A mirror bar chart or double bar chart is a special type of bar chart (actually, a simplified version of a diverging chart referred to as a comparative histogram) that displays two sets of data comparatively side by side along the vertical axis. The chart resembles a reflection of a mirror, hence the name "mirror bar chart":

How to show Likert scale chart (integrated neutral)

To analyze poll or survey results, it is important to see the actual numbers and the difference between all negative and positive answers. Often such results are presented as a spread of negative and positive Likert values, such as "Strongly disagree" and "Strongly agree".

How to create a comparative histogram chart in Excel

Excel for Microsoft 365 offers several new pre-defined charts, including the histogram chart. This pre-defined chart makes possible to create different types of histogram charts with little effort.

How to create a Mosaic plot in Excel

Pie and bar charts greatly simplify the understanding of percentages distribution for one categorical variable but fail to build a meaningful representation of two and more variables. A quite recent innovation in data visualization real is the Mosaic plot, which helps to grasp the correlations within marketing, sales, and other financial data. You will not find this chart among Excel standard charts, but you can build one.