Custom Log Scaling

C

C Schultz

Is there a way to customize the log base for a chart
axis? I would like to have the x-axis to be N^1.85.

Thanks

Courtney Schultz
 
T

Tushar Mehta

[This followup was posted to microsoft.public.excel.charting with an
email copy to C Schultz.
Please use the newsgroup for further discussion.]

In a separate column, use whatever transformation you want to implement
(X^1.85 in your example). Then, use this new column as the X-values
for your chart.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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

Similar Threads

Gantt chart duration not showing 0
Problem with Excel 2007 clustered column chart on log scale 1
Graphing n^1.85 1
Log scale and minor gridline labels 2
Logarithmic Scale for the X-Axis 1
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
Custom Format numbers for learning chart 0

Top