ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Minor gridlines in Logarithmic scales (https://www.excelbanter.com/charts-charting-excel/58448-minor-gridlines-logarithmic-scales.html)

Plinth Murex

Minor gridlines in Logarithmic scales
 
Is there a way to have Excel show smaller divisions inside of the minor
gridlines ("sub-minor gridlines") in a logarithmic scale, when doing a chart?
I currently use an Excel 2002 application program.
--
Plinth Murex

Andy Pope

Minor gridlines in Logarithmic scales
 
Hi,

You can use a dummy data series to add your own gridlines.
See Jon Peltier's explanation, which you can adapt.
http://peltiertech.com/Excel/Charts/...Gridlines.html

Cheers
Andy

Plinth Murex wrote:
Is there a way to have Excel show smaller divisions inside of the minor
gridlines ("sub-minor gridlines") in a logarithmic scale, when doing a chart?
I currently use an Excel 2002 application program.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Plinth Murex

Minor gridlines in Logarithmic scales
 
Thanks, Andy. If you come across another way of doing, please give me a post.

Best Regards,
Plinth
--
Plinth Murex


"Andy Pope" wrote:

Hi,

You can use a dummy data series to add your own gridlines.
See Jon Peltier's explanation, which you can adapt.
http://peltiertech.com/Excel/Charts/...Gridlines.html

Cheers
Andy

Plinth Murex wrote:
Is there a way to have Excel show smaller divisions inside of the minor
gridlines ("sub-minor gridlines") in a logarithmic scale, when doing a chart?
I currently use an Excel 2002 application program.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info



All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com