Excel log/log chart

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.
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top