Excel log/log chart

  • Thread starter Thread starter Curt Horner
  • Start date Start date
C

Curt Horner

Using the previous version of Microsoft Excel (Excel '95),
I was easily able to produce a log/lock chart, using the
scatter chart as a starting point, without any problem
whatsoever. This included placing two and more series on
the same chart. With the new version that is installed on
my machine (which is Excel 97), I can no longer complete
this rather simple task. Does anyone know how to produce
a log/log chart of two and more sets of values (using X-Y
values)?
My Desire Is to Have One Set of X-Y values with another
set (A-B) of values as well as a third set of values (M-N)
placed on the same log/log chart.
With Excel '95, this was a relatively easy task.
 
Curt -

How new is that new computer <g>?

Make sure you are making an XY Scatter chart. Create it using the first
two ranges (X1 and Y1). Copy your next two ranges (X2 and Y2), select
the chart, and use the Paste Special command on the Edit menu to add the
selected data as a new series. Repeat for (X3,Y3) and additional series.

- Jon
 
Back
Top