Windmill Software Ltd
Data Acquisition Intelligence

Charting and Excel
May 2001

------------------------Monitor-------------------------
The Newsletter for PC-Based Data Acquisition and Control
Issue 34         www.windmill.co.uk             May 2001
--------------------ISSN 1472-0221----------------------

Thank you for subscribing to Monitor. This month we're 
focusing on charting and Excel. 

We only send this newsletter to people who have 
subscribed - should you wish to cancel your free 
subscription please visit 
http://www.windmill.co.uk/newsletter.html

CONTENTS
========
* Windmill News: New Guide to using Windmill with Excel
* Windmill Charting Tips
* Excel Corner: Charting with Excel
________________________________________________________

Windmill News: New Guide to using Windmill with Excel
________________________________________________________

Learn about the ways to get real-world data into Excel. 
From simply importing previously logged data, to fully 
automated collection and analysis in Excel.
http://www.windmill.co.uk/excel/
________________________________________________________

Windmill Charting Tips
________________________________________________________

If you've downloaded the free Windmill Software suite 
you'll have seen our Chart program. Here are a couple 
of tips on using Windmill Chart.

Incorporating the Chart in your Report
  Whilst Chart is the active window, press the Alt and 
  Print Screen keys. This copies the Chart image to the 
  clipboard. Now simply paste the picture of Chart into 
  your Word, Excel or other Windows-based report. This 
  is also useful when printing the Chart, as you can 
  annotate the image as necessary. 

Showing Data Over a Longer Time-Scale
  To show data over a longer time-scale, and thus 
  display more data, just change the "paper speed". For 
  example, if the Chart window is 5 cm wide and your 
  paper speed is 5 cm per second, you will see 5 
  seconds of data. If your paper speed is 5 cm per 
  minute, you will instead see 5 minutes of data.

For more details on Windmill Chart see
http://www.windmill.co.uk/chart.html
________________________________________________________

Excel Corner: Charting with Excel
________________________________________________________

Spreadsheets are very useful tools for analysing your 
data. You can average readings over time or number of 
sampling points, or put data directly into reports. You 
can collect data with the free Windmill Logger program 
and after collection has finished import it into your 
spreadsheet. Alternatively you can transfer data as it 
arrives, using dynamic data exchange. For details of how
to do this see 
http://www.windmill.co.uk/excel/

Although this article concentrates on Excel, many of the 
comments here also apply to other spreadsheet programs.

This Excel Corner looks at charting with Excel. But 
first, do you need to use Excel to chart your data? It 
may be that Windmill's free, real-time charting program 
is all that is necessary. Or, for re-running charts 
after collection has finished, you could use the 
Windmill Replay software. This lets you rewind, fast-
forward, zoom in, zoom out and scroll through large 
data files looking for areas of interest. (More 
details on Windmill Replay are at 
http://www.windmill.co.uk/replay.html)
A third Windmill program, Windmill Graphics, lets you 
display a bar chart of the current data: a 
continuously changing snapshot of the live situation.

So why use Excel to chart data?

1. Windmill Chart and Replay always plot data against 
   time. With Excel you could plot, for example, 
   temperature against depth.
2. Excel offers many different styles of chart - you may 
   decide a stock chart, say, suits your purpose better 
   than the Windmill charts.

                           *

Choosing the Type of Excel Chart to Use

Excel provides a multitude of chart styles and it can 
sometimes be confusing which one is the best to use. 
Here we highlight three well suited to data acquisition 
- stock, bar & column and xy scatter.

Stock Chart: Useful for Displaying High, Low and Average 
Readings

 A stock chart shows high, low and close data. This is 
 designed for plotting stock market movements, but can be 
 useful when plotting, say, daily temperatures. To plot 
 the temperature range for each day you would have the 
 date in the first column, the highest temperature of the 
 day in the next column, the lowest temperature in the 
 third column, and, for example, the average temperature 
 of the day in the fourth column - replacing the stock 
 market close data.

Column and Bar: Good for Displaying Counts

 Column and bar charts are useful for comparison of 
 discrete measurements made at regular intervals. For 
 example, if you were counting people entering a 
 building, you might use a column chart to show count 
 totals for a series of days or weeks. To display data 
 from several buildings you could use a stacked column 
 chart, where figures for each building are shown as a 
 part of the total column count. 

 A column chart has time on the horizontal x-axis 
 and a bar chart time on the vertical y-axis. If 
 you have too many columns, Excel won't display 
 all the column labels. Displaying data in bars 
 removes this problem.

Line Charts Versus xy Scatter

 You would usually use an xy scatter chart in preference 
 to a line chart. With xy scatter an independent variable 
 is plotted on the x-axis and variables dependent upon 
 this plotted on the y-axis. When you add a trend line, 
 you can see the relationship between the variables. For 
 example you might see a linear relationship between the 
 concentration of a compound in solution and its 
 absorbance of light.

 With Line charts the x values are more like labels than 
 values. They are spaced equally, no matter what their 
 value. Using our above example, suppose you plotted 
 absorbance against the concentration of four solutions 
 of 0, 1, 2 and 6 mM. With xy scatter the line will be 
 straight as the 6mM point is plotted in its correct 
 position 4 units away from the 2 mM point. With a line 
 chart the 6mM point is plotted just 1 unit away from 
 the 2 mM point, giving a steep rise in absorbance and 
 thus non-linear graph. 

                           *

Excel Tip of the Month: Quickly Adding New Data to an 
Excel Chart

Suppose you have used Windmill to log rainfall and 
atmospheric pressure data. You import the data file 
into Excel and have 3 columns: Time, Rainfall and 
Pressure. You create a chart plotting rainfall against 
time. You now decide to add the pressure data to the 
chart:
- Highlight the pressure column
- Move the mouse pointer over the edge of the 
  highlighted data, so it changes to an arrow
- Click and drag the column onto the chart
Rainfall and pressure are now plotted against time.

This tip courtesy OzGrid Business Applications. More 
charting tips are available on their web site.
https://www.ozgrid.com/

________________________________________________________

* Copyright Windmill Software Ltd
* Reprinting permitted with this notice included
* For more articles see http://www.windmill.co.uk

We are happy for you to copy and distribute this 
newsletter, and use extracts from it on your own web site 
or publication, providing the above notice is 
included and a link back to our website is in place.

An archive of previous issues is at 
http://www.windmill.co.uk/newsletter.html
and an index of articles at 
http://www.windmill.co.uk/newsletter.html

Windmill Software Ltd, PO Box 58, North District Office,
Manchester, M8 8QR, UK
Telephone: +44 (0)161 833 2782
Facsimile: +44 (0)161 833 2190
E-mail: monitor@windmillsoft.com
http://www.windmill.co.uk/
https://www.windmillsoft.com/



Subscribing

To receive Monitor every month please fill in your e-mail address below. We will not pass your address to any third parties, nor send you any unsolicited e-mail.

Monitor Archive

Home
Newsletters
Contents


Subscribe to Monitor
for more articles and tutorials

:




You will receive an e-mail asking you to confirm your subscription. On doing so you will be sent details of how to download the free software. If you don't receive this e-mail please contact monitor@windmillsoft.com.

You can read an archive of previous issues on our Data Acquisition Intelligence site.

Cancel Subscription

You can cancel your free subscription at any time - just return to this page or follow the instructions in the newsletter.

Previous Issue Next Issue