Chart in Excel 2013
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.