I am working on a display of small multiples (Tufte-style collection
of many small graphics,
derived from data in a worksheet). Each of the graphics (charts) uses
a logarithmic scale.

I would like to create a worksheet that displays a collection of small
line graphics, with a
logarithmic scale dependent on the max and min values of the data set
(two rows of data
per chart, 4 values per row), and the background color of each line
graph chart set to one of
three possible colors, depending on those max and min values. For
instance, for data that
ranges from 0 up to 1000, a light blue background; for data ranging
from 1001 to 100,000,
a light yellow background, and anything larger than 100,001 getting a
light tan background.
Line thickness, dot size, and colors of lines and dots would be
consistent from chart to chart.

I've created this sort of display "manually", but the data will be
updated several times before
the final version is due, so I'd like to automate as much as possible.

Now here's an additional issue: when generating the charts manually,
the size of the charts
and the distance between lines of the logarithmic "Y" scale are not
consistent from chart to
chart.

So....

Two questions:
1) How do I generate a series of small multiples like this?
2) If I need to do some manual work to get this going, is there some
way to at least generate
charts with consistent sizes and consistent distances between
lines of the logarithmic "Y"
scales?

Many thanks for help.