Adjust the Scales on the X and Y Axis
The chart that you get when you have finished with the wizard does not look that impressive. You
need to apply some customized formatting to your chart to make it into a visually appealing analytical
tool.
Right click on the Y axis, choose Format Axis… and select the
Scale tab. The Excel chart wizard usually assigns zero as the minimum value. This leaves a
great deal of wasted space below the price chart. Change the minimum value and the maximum value to reflect the high and low points reached for the period you are
trying to display. You can also click on the Number and Font tabs to customize the way you
want your fonts and numbers to appear on the vertical axis.
Customize the Up and Down Bars
In order to be better able to recognize the patterns in a candlestick chart you need to adjust the
appearance of the up and down bars. Unlike the standard bar chart the candlestick is composed of high
low lines and these can be up or down bars depending on the price movement. Right click on the one of
the down bars on the chart in order to format its appearance.
Use the style, color and weight drop-downs to customize the appearance of the down bars. In our case we
selected the color red to identify the down bars.
Follow the same procedure to customize the appearance of the up bars.
|
