Creating Confidence Interval Charts with OpenOffice

To obtain the following graph:
ci (6K)

One has to set up a table in OpenOffice with the following layout:


Low High Mean
Chuuk 1.58 2.17 1.88
Kosrae 1.94 2.81 2.38
National 1.7 2.08 1.89
Pohnpei 1.2 1.95 1.57
Yap 2.08 2.78 2.43

Then one makes a graph using the "stock market" bar charts:
ci1 (51K)

At the next screen take the first option:
ci2 (56K)

Now comes the fun part: double click on various elements to change the line widths and appearance.  This will take some experimenting and careful mouse work.  The choice of scale such as to make the confidence interval lines long enough to double click on the line element is useful.  As you roll over various elements a pop up dialog should describe what the element is prior to double clicking the element.  I double click the line center to assign a gallery image to the mean, producing the center ball. 

When I have what I want, I click on the graph to select it, copy it, and paste it into the drawing package.  Then I export the image as a GIF or PNG for use in my web pages.  Although I occasionally use OpenOffice to build my web pages, I tend to prefer HTML Kit from http://www.chami.com, a free web page development environment that is tag oriented.   HTML Kit lets me build clean, fast, HTML and XHTML compliant pages with CSS.

In addition, if you save web pages from Calc the graphs are converted to JPEGs.  When you print the resulting web page one gets "ghosting" around the text elements.  Use of GIF or PNG produces a clean print image.

I hope this helps in some way!

EquationsTrainingCoursesCOMFSM