Chart in Excel 2013 2010 2007 2003

How to create a simple interactive chart with radio or option buttons

There are a lot of different features in Microsoft Excel, that can be useful for creating a presentation of your data. One of these features is interactive controls, that can be added to your Excel spreadsheet to create dynamic charts. This tip is about using Option Buttons that can be easily added and customized.

Show chart data for empty cells

When you have some gaps in your chart data, Excel doesn't show any data for these gaps and your chart looks odd. Instead you can show interpolated values instead of gaps in the chart.

Show chart data in hidden cells

When you have some hidden cells in your chart data, Excel ignores data for these gaps and doesn't show the corresponding chart elements.

How to add a horizontal line to the chart

Sometimes you need to add a horizontal line to your chart. E.g., this will be useful to show data with some goal line or limits:

How to create a flowchart with SmartArt

A flow chart usually shows steps in a task, process or workflow. There are many different SmartArt templates predefined in Excel that you can use to illustrate the process, including some complex templates with pictures.

Draw a flowchart in Excel

A flowchart or flow chart usually shows steps of the task, process or workflow. There are many different SmartArt templates predefined in MS Excel that you can use to illustrate the process, including visually appealing templates with pictures.
However, if you want to use different shapes and a complex topology it is better to create your own flowchart.

How to make your data changes in the chart more informative

Simple line and bar charts often attract little or no interest of the audience, but Excel allows you to attract an attention to your data by emphasizing change direction, difference or period.

Improve axes format in Excel

Very few Excel users pay an attention to the chart axes, but there are some tricks with axes that will help you to improve your visualizations with little or no efforts.

How to combine different data in one chart

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

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.