ExcelBanter - I want to produce a log-log chart. Logrithmic scale on both axis.

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - I want to produce a log-log chart. Logrithmic scale on both axis. (https://www.excelbanter.com/charts-charting-excel/278-i-want-produce-log-log-chart-logrithmic-scale-both-axis.html)

transco

I want to produce a log-log chart. Logrithmic scale on both axis.

Jon Peltier

You need to chart the data in an XY Scatter chart (not a Line chart). You can choose
an XY Scatter chart subtype that connects the markers with lines. Then double click
each axis, and on the Scale tab, check the Logarithmic Scale checkbox.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

transco

Thanks a lot. I'll try this.

"transco" wrote:

All times are GMT +1. The time now is 12:52 AM.