When Excel is installed, the default chart is a 2-D Column chart but you can easily change the default chart type.

When you create a chart with a scroll bar, it will be useful create a chart with all data to see which data fragment you see in the scrolling chart.

Sometimes you need to create a chart that shows a large data amount. Then it would be useful to insert a scroll bar in your chart.

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

In this tip we will show how to different charts could be combined in the one chart. In example we will combine a Bubble chart with an Area 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 for this, available in two locations along the Layout tab of the ribbon.

Expressiveness of business graphics sometimes determines the success or failure of the presentation and you can achieve better perception of the audience by using in charts intuitively obvious representation of data by arrows.

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.

If you need to create a simple Gantt chart, see Creating a Gantt chart or Gantt chart with progress. To add events to your Gantt chart, see Progress Gantt chart with events. This tip will help you to extend those charts by a vertical line that shows the current date.

Every workbook uses a palette of 56 colors, but you can change palette for the current workbook or even change the default colors for new workbooks.