Hello Alb,
As the comment notes, the "Stock" chart type is certainly one you can
use. It typically generates a very thin line as the range of values
(low to high). The [optional] close value is shown as a slightly wider
tick mark on the right side.
If you want a thicker look for this type of chart, and add a label to
each vertical bar, do the following steps:
[1] Create the stock chart. For information, the order of data (as
described in the help file) is:
Date, Low, High, Close
but if you have several stock symbols / dates to show - I suggest
putting that in the "date" column.
[2] Select one of the vertical lines. Do a right click to bring up a
pop up menu and select Format High Low Lines. Change the style to the
fat bar and to the widest weight (and set color if desired) and then
OK.
The bars at this point should have some width to them.
[3] Select the bottom of one of the lines. Do a right click to bring
up a pop up menu and select Format Data Series. One of the tabs is
Data Label, select that. If you "Show Label" [and then OK], the value
in the "date" column will appear on the chart next to each bar.
[4] Select the one of the labels. Do a right click to bring up a pop
up menu and select Format Data Labels. On the Alignment tab, I suggest
setting the Label Position to "above" and rotate the text 90 degress
[and then OK].
[5] If you need to override the label on any individual bar, double
click on the label to select it, drag over the existing value and type
in the name you want instead. This change applies to each label on an
individual basis.
The above method uses the existing Stock chart type to get the effect you want.
Another method is to use a "Column" chart and make the low value (and
its column) transparent. The steps are:
[1] Create the column chart, be sure to select the "Stacked Column"
type. If you do this, the data columns should be
"Date (or label)", Low value, Range (High - Low)
[2] You will get a chart with the top part of each column showing the
range of values and need to make the lower part of the column
disappear. Select a lower column and right click to get the pop up
menu. Select Format Data Series and set the format of the area and
line to "none" [and then OK].
[3] Select one of the columns still visible and right click to bring
up the pop up menu. Select Format Data Series and add the label /
format it in a manner similar to above.
This should look similar to the format you asked for with a slight
change in the type of data being charted. The first method uses low /
high, the second uses low / range.
If this answer is unclear or you need further assistance in formatting
your chart, please make a clarification request.
--Maniac |
