Chart in Excel 365 2016 2010 2007 2003

Waterfall chart using Error bars

The waterfall chart is normally used for understanding how an initial value is affected by a series of intermediate positive or negative values. As we have shown Creating a Waterfall chart it can be created using a combination of Excel Bar charts. This tip will show you how streamline this process using Error Bar chart. The waterfall chart is normally used for understanding how an initial value is affected by a series of intermediate positive or negative values.

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.

Excel 3-D Pie charts

This tip is about how to create a pie chart such as in popular glossy magazines.

How to add deviations into your chart

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

Using Pie Charts and Doughnut Charts in Excel

If you have several parts of something one, you can demonstrate each item in one pie chart. But sometimes you want to demonstrate the changes of those parts and doughnut chart will help you to do this.

How to fix the chart data

You can unlink a chart from its data ranges and produce a static chart that remains unaffected by later changes in the data.

Creating a Gantt chart

A Gantt chart is a horizontal bar chart that is often used in project management applications like Microsoft Project.

Creating a simple thermometer chart

You're probably familiar with a "thermometer" type display that shows the percentage of a task that's completed. It's very easy to create such a display in Excel.

Creating picture charts

Excel makes it easy to incorporate a pattern, texture, or graphic file for elements in your chart. E.g., you can create funny burger sales chart for your colleagues.

Conditional formatting for chart axes

Another powerful trick to attain the attention of the audience and improve the effect of your presentation is to use axis label formatting customized for the specific value ranges.