Bob,
Most charts are category charts. On the x axis are equally spaced
categories (Apples, Oranges, etc.), and their associated values are plotted
on the Y axis, optionally logarithmically. It sounds as though you need to
plot points, with both their X and Y values supplied. For that, use the
Scatter XY chart type. That type has both X and Y value axes, either or
both of which can be made logarithmic. The points can be optionally
connected with lines.
You may wish to use .public.excel.charting for further questions. The
charting gurus hang out there.