How to create Master and Scrolled Detail charts

Scroll charts are often created to view detailed information for a small data range from a large dataset. For example, it is convenient to view weekly changes over a longer period of time, such as several months. Depending on the selected scroll step, you can view changes daily or weekly by moving the scroll bar.

How to create PowerPoint progress pie chart

Today there are two popular design styles: Material Design from Google and Metro UI from Microsoft. Both use a flat circular progress indicator. This tip shows how to create a similar progress indicator for your presentation.

Using two axes in one chart

Sometimes you want to show several axes in one chart to demonstrate each data series with different formatting and with different axis in one chart.

How to combine different data in one chart

To make your data more information, you can combine different chars in many ways.

Adding Up/Down Bars to a line chart

If you have a line chart with two different data series, you might want to compare those series at each point along the horizontal axis. There are two different options available in two locations, along with the Chart Design tab of the ribbon:

A quick way to duplicate all of the custom chart formatting

The creation of a large number of visually consistent charts to represent different data is a time consuming and error prone task unless you know how to copy formatting between charts.

How to create a perfect Gantt chart

Gantt charts illustrate project schedules and, thus, often used by project managers. Project management tools like Microsoft Project are better suited for Gantt charts, but it is easy to create a Gantt chart in Excel following the simple steps.

How to create a combination chart in PowerPoint

Is it really necessary to create a chart in Excel and then import it to your PowerPoint presentation? Here you will see how to create a complex chart in PowerPoint that later will be used for adding additional effects.

Competition chart with residual data

When analyzing or presenting data in comparison or competitive charts, it is useful to see the points scored or results achieved and the remaining points to complete the Goal. For example, you can easily create a simple competition chart with residual data:

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.