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