Membuat Grafik Sondir Menggunakan Ms ExCeL 2007 Suatu kemudahan untuk menggunakan buku ini karena menyajikan tampilan instruksi yang akan memudahkan bagi para pembaca untuk mencoba menjalankannya Buku ini menyajikan tampilan instruksi yang akan memudahkan bagi para pembaca untuk mencoba menjalankannya. Gunawan 1/1/2009
Daftar Gambar
Gambar 1. Data Sheet. .............................................................................................................. 2 Gambar 2. Klik Kanan Satu Kali Insert. ................................................................................. 3 Gambar 3. Kotak Dialog Insert General. ............................................................................... 3 Gambar 4. New Chart................................................................................................................. 4 Gambar 5. Shortcut Change Chart Type. .................................................................................. 5 Gambar 6. Box of Change Chart Type. ..................................................................................... 5 Gambar 7. Icon Shortcut Select Data. ....................................................................................... 6 Gambar 8. Box of Select Data Source. ...................................................................................... 7 Gambar 9. Demove All Default Data. ......................................................................................... 8 Gambar 10. Box of Edit Series From Add Icon.......................................................................... 9 Gambar 11. Bar of Edit Series After Series Name. ................................................................... 9 Gambar 12. Input Data From “Data Sondir” Sheet. ................................................................. 10 Gambar 13. View of Series Name Range. ............................................................................... 11 Gambar 14. View of All Data Range. ....................................................................................... 12 Gambar 15. Graf Preview Add Next Input. .......................................................................... 13 Gambar 16. Box of series Name. ............................................................................................. 13 Gambar 17. Range Input. ......................................................................................................... 14 Gambar 18. View of All Data Range. ....................................................................................... 14 Gambar 19. Graf Preview OK to Execute. .......................................................................... 15 Gambar 20. Change Chart Type. ............................................................................................. 16 Gambar 21. Graf Preview After Change. ................................................................................. 17 Gambar 22. Right Clikck Format Axis. ................................................................................ 17 Gambar 23. Format Axis Values in Reverse Order. ........................................................... 18 Gambar 24. Values in Reverse Order...................................................................................... 19 E-maiL:
[email protected]
ii
Gambar 25. Toch Red Line Right Click Format Data Series. ........................................ 19 Gambar 26. Box of Format Data Seriaes Secondary Axis. ................................................ 20 Gambar 27. Layout Labels Legend Show Legend at Bottom. ................................... 21 Gambar 28. Layout Axes Secondary Horizontal Axis Show Default Axis. ................ 22 Gambar 29.Preview Secondary Axis. ...................................................................................... 23 Gambar 30. Right Click Secondary Vertical Axis Format Axis. .......................................... 23 Gambar 31. Box of Format Axis Values in Reverse Order. ................................................ 24 Gambar 32. Preview Dual Axis. ............................................................................................... 25 Gambar 33. Primary Horizontal Interval. Right Click Horizontal Axis Format Axis. ........... 26 Gambar 34. Box of Format Axis Axis Option Maximun & Major Unit Value. ................. 27 Gambar 35. New Horizontal Interval Value. ............................................................................ 28 Gambar 36. Layout Chart Title Above Chart. ................................................................. 28 Gambar 37. Preview Chart Title. .............................................................................................. 29 Gambar 38. Layout Axis Title Primary Vertical Axis Title Rotated Title..................... 30 Gambar 39. Layout Axis Title Primary Horizontal Axis Title Title Below Axis. .......... 31 Gambar 40. Preview Axis Title. ................................................................................................ 32 Gambar 41. Layout Axes Gridlines Primary Vertical Gridlines Major & Minor Gridlines. ................................................................................................................................... 33 Gambar 42. Finish. ................................................................................................................... 34
E-maiL:
[email protected]
iii
1 PENGANTAR Prigram ini diberikan kepada personal yang berhubungan dengan analisis daya dukung tanah untuk pondasi bangunan. Pengujian daya dunkung tanah dilakukan dengan alat Sondir.
1.1 Keunggulan 1. Grafik daya dukung tanah akan muncul dengan otomatis. 2. Memudahkan pembuatan organisasi data.
1.2 Kesulitan Terdapat banyak file master yang dibuat.
1.3 Kerugian 1. Membutuhkan banyak kertas untuk mencetak data input untuk analisis.
2 Gambar Kerja
Gambar 1. Data Sheet.
E-maiL:
[email protected]
2
Gambar 2. Klik Kanan Satu Kali Insert.
Gambar 3. Kotak Dialog Insert General.
E-maiL:
[email protected]
3
Gambar 4. New Chart.
E-maiL:
[email protected]
4
Gambar 5. Shortcut Change Chart Type.
Gambar 6. Box of Change Chart Type.
E-maiL:
[email protected]
5
Gambar 7. Icon Shortcut Select Data.
E-maiL:
[email protected]
6
Gambar 8. Box of Select Data Source.
E-maiL:
[email protected]
7
Gambar 9. Demove All Default Data.
E-maiL:
[email protected]
8
Gambar 10. Box of Edit Series From Add Icon.
Gambar 11. Bar of Edit Series After Series Name. E-maiL:
[email protected]
9
Gambar 12. Input Data From “Data Sondir” Sheet.
E-maiL:
[email protected]
10
Gambar 13. View of Series Name Range.
E-maiL:
[email protected]
11
Gambar 14. View of All Data Range.
E-maiL:
[email protected]
12
Gambar 15. Graf Preview Add Next Input.
Gambar 16. Box of series Name.
E-maiL:
[email protected]
13
Gambar 17. Range Input.
Gambar 18. View of All Data Range.
E-maiL:
[email protected]
14
Gambar 19. Graf Preview OK to Execute.
E-maiL:
[email protected]
15
Gambar 20. Change Chart Type.
E-maiL:
[email protected]
16
Gambar 21. Graf Preview After Change.
Gambar 22. Right Clikck Format Axis.
E-maiL:
[email protected]
17
Gambar 23. Format Axis Values in Reverse Order.
E-maiL:
[email protected]
18
Gambar 24. Values in Reverse Order.
Gambar 25. Toch Red Line Right Click Format Data Series.
E-maiL:
[email protected]
19
Gambar 26. Box of Format Data Seriaes Secondary Axis.
E-maiL:
[email protected]
20
Gambar 27. Layout Labels Legend Show Legend at Bottom.
E-maiL:
[email protected]
21
Gambar 28. Layout Axes Secondary Horizontal Axis Show Default Axis.
E-maiL:
[email protected]
22
Gambar 29.Preview Secondary Axis.
Gambar 30. Right Click Secondary Vertical Axis Format Axis.
E-maiL:
[email protected]
23
Gambar 31. Box of Format Axis Values in Reverse Order.
E-maiL:
[email protected]
24
Gambar 32. Preview Dual Axis.
E-maiL:
[email protected]
25
Gambar 33. Primary Horizontal Interval. Right Click Horizontal Axis Format Axis.
E-maiL:
[email protected]
26
Gambar 34. Box of Format Axis Axis Option Maximun & Major Unit Value.
E-maiL:
[email protected]
27
Gambar 35. New Horizontal Interval Value.
Gambar 36. Layout Chart Title Above Chart.
E-maiL:
[email protected]
28
Gambar 37. Preview Chart Title.
E-maiL:
[email protected]
29
Gambar 38. Layout Axis Title Primary Vertical Axis Title Rotated Title.
E-maiL:
[email protected]
30
Gambar 39. Layout Axis Title Primary Horizontal Axis Title Title Below Axis.
E-maiL:
[email protected]
31
Gambar 40. Preview Axis Title.
E-maiL:
[email protected]
32
Gambar 41. Layout Axes Gridlines Primary Vertical Gridlines Major & Minor Gridlines.
E-maiL:
[email protected]
33
Gambar 42. Finish.
E-maiL:
[email protected]
34
