Logarithmic charts on different axis

A

Allenx

Is it possible for Excel to create a hybrid logarithmic chart where the
X-axis is the log scale and the Y axis is the linear scale?

In trying to accomplish this, I notice the Y-axis format dialog box has a
logarithmic checkbox option, but I do not see an equivalent option checkbox
for the X-axis.

I eventually want the X-axis to show a market volume reference starting from
small numbers and growing as it gets further from the origin, and the Y axis
to be a market price, stating at a high value near the origin and declining
as one moves up the Y-axis.
 
D

Del Cotter

Is it possible for Excel to create a hybrid logarithmic chart where the
X-axis is the log scale and the Y axis is the linear scale?

In trying to accomplish this, I notice the Y-axis format dialog box has a
logarithmic checkbox option, but I do not see an equivalent option checkbox
for the X-axis.

You must choose an XY (Scatter) Chart type instead of a Line Chart type.
"Line" charts have a category X-axis, which can be neither linear nor
logarithmic. It's just a list of categories. Scatter charts have a
"Value" or interval X-axis, which you can then choose to make linear or
logarithmic.
 

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