Purpose
When a range of values for different data series in a chart varies widely, or when you have mixed types of data (such as price and volume), you can plot one ore more data series on a secondary value axis.
The scale of the secondary axis reflects the values for the associated series.
Workinstruction
The instructions apply to [...]
In this example the maximum value will automatically display a green arrow instead of the standard marker.
At the end of this article, you’ll find the demo file.
How is this done ?
When the values of a serie differ too much from the other series, it is very often quite difficult to display these high values in a stacked chart.
In the following screenshot, the serie with the high values has been plotted on a secondary axis.
How is this done ?
Don’t you hate it when there’s to many categories…like in the screenshot below ?
But what do you think about the screenshot below ?
How is this done ?
This exercise demonstrates how to link a chart’s title to the content of a cell.
In this case, the cell contains the formula =”Chart for “&TEXT(NOW(),”dd-mm-yyyy”).
The second part of the formula results in the current date.
Enter the formula =”Chart for “&TEXT(NOW(),”dd-mm-yyyy”) in the cell A1
Select the title of the chart, and key “=” and select the [...]