Excel propose easy and very fast way to create a chart by using shortcut keys.
To emphasize differences between data in the chart it will be interesting to create a column chart in which
the color of each column depends on the value displayed.
When Excel is installed, the default chart is a 2-D Column chart but you can easily change the default chart
If you often need to adjust your data ranges so that your charts plot an updated data range, you may be
interested in a trick that forces Excel to update the chart's data range whenever you add new data to your
Creation of a large number of visually consistent charts to represent different data is a time consuming and
error prone task, unless you know how to copy formatting between charts.
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.
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.
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:
You can unlink a chart from its data ranges and produce a static chart that remains unaffected by later
changes in the data.