Chart in Excel 2016 2010 2007 2003

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.

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 of 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.

Adding a trend line

When you're plotting data over time, you may want to plot a trend line that describes the data. A trend line points out general trends in your data.