Date Volume High Low Close
1-Jan-07 41,301 27.20 23.49 25.45
2-Jan-07
3-Jan-07
35,203
27,908
25.03
19.05
19.55
15.12
23.05
17.32
Volume Share Volumes / Prices Price
4-Jan-07 29,567 20.33 17.84 20.45 45,000 30.00
5-Jan-07 25,895 18.56 16.33 17.35
40,000
25.00
35,000
30,000 20.00
25,000
15.00
20,000
15,000 10.00
10,000
5.00
5,000
0 0.00
Format as Custom dd-mmm-yy 1-Jan-07 2-Jan-07 3-Jan-07 4-Jan-07 5-Jan-07
Format as Number 1-Jan-07 2-Jan-07 3-Jan-07 4-Jan-07 5-Jan-07
Volume 41,301 35,203 27,908 29,567 25,895
High 27.20 25.03 19.05 20.33 18.56
Low 23.49 19.55 15.12 17.84 16.33
Status: Complete. Close 25.45 23.05 17.32 20.45 17.35
Microsoft's Number
1 Highlight the range A 1 to E 6. 2
2 Insert / Charts group / click on arrow in lower right hand corner / Insert Chart pane should launch / Stock / Volume-High-Low-Close / OK 3
Chart should launch.
3 Click in the chart to highlight it / Format / Current Selection group / in the Chart Element box (the only one that has a drop down arrow in it) make sure that
Chart Area is selected. 5
Chart Tools / Design / Chart Styles group / click on the More drop down arrow in the lower right hand corner / click on Style 26 6
4 Click in the chart to highlight it / Format / Current Selection group / in the Chart Element box (the only one that has a drop down arrow in it) make sure that 7
Chart Area is selected.
Chart Tools / Design / Chart Layouts group / click on the More drop down arrow in the lower right hand corner / click on Layout 4
5 Click in the chart to highlight it / Chart Tools / Format / Size group / set Shape Height and Shape Width to read 12.5 cm / (this is 5 inches if you are working in 8
inches and not centimetres).
6 Click in the Chart Title and change its description to read Share Volumes / Prices at the same time givinf the text a Font Size of 14. 9
7 Click in the chart to highlight it / Format / Current Selection group / in the Chart Element box (the only one that has a drop down arrow in it) make sure that 11
Chart Area is selected.
Chart Tools / Format / Shape Styles group / click on the drop down arrow that has More over it when you hover your mouse over it / click on Subtle Effect -
Accent 6
8 Click in the chart to highlight it / Format / Current Selection group / in the Chart Element box (the only one that has a drop down arrow in it) make sure that 11
Plot Area is selected.
Chart Tools / Format / Shape Styles group / click on the drop down arrow that has More over it when you hover your mouse over it / click on Subtle Effect -
Accent 3
9 Finally I added the Text Boxes for Volume (top left hand corner) and Price (top right hand corner).
F 1 Help Facility
Browse Excel Help
Charts
Chart types
Present your data in a stock chart
Status: Complete.
Date Amount Percentage Text
22-Jul-07 1,000 1.00%
22-Aug-07 2,000 2.00%
22-Sep-07 3,000 3.00%
22-Oct-07 4,000 4.00%
22-Nov-07 5,000 5.00%
22-Dec-07 6,000 6.00%
22-Jan-08 7,000 7.00%
22-Feb-08 8,000 8.00%
22-Mar-08 9,000 9.00%
22-Apr-08 10,000 10.00%
22-May-08 11,000 11.00%
Format as Custom dd-mmm-yy
Format as Number
Format as Percentage 2 decimal places.
Format as Text.
Status: Complete.
In Progess.