Chart in Excel 2007
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.
How to create Master and Scrolled Detail charts
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.
How to create a 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.
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.
Bubble and Area chart
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:
Adding Up/Down Bars to a line 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.
Using Arrows in a Chart
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.
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.
Glossy Gantt chart with a vertical line
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.
How to change the default colors that Excel uses for chart series
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.