# Logarithmic Scale - Tic Label Disappearance

1. ## Logarithmic Scale - Tic Label Disappearance

My chart has y-axis values on a scale from 10 to 100 in increments of 10 per
each tic. When I set the scale to logarithmic, the only two tic values left
appearing on the axis are 10 and 100. How do I get the values 10, 20, 30,
...., 100 all to appear on the axis?

2. ## Re: Logarithmic Scale - Tic Label Disappearance

On a log scale, the powers of ten are the major ticks, and the in between ticks are
the minor ticks. Only major ticks have labels.

You could use a dummy series to add tick labels, using the following example. You
don't need to use crosses on the dummy points, use the minor ticks instead. Use the
values as labels (20, 30, etc.) and the logs of these as the coordinate along the axis.

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

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

howie1 wrote:

> My chart has y-axis values on a scale from 10 to 100 in increments of 10 per
> each tic. When I set the scale to logarithmic, the only two tic values left
> appearing on the axis are 10 and 100. How do I get the values 10, 20, 30,
> ...., 100 all to appear on the axis?

3. ## Re: Logarithmic Scale - Tic Label Disappearance

See Flexible Log Scale
http://www.tushar-
mehta.com/excel/newsgroups/flexible_log_scale/index.html

--
Regards,

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

In article <34FF5F0F-2472-44FE-8549-7C366ED17E29@microsoft.com>, howie1
@discussions.microsoft.com says...
> My chart has y-axis values on a scale from 10 to 100 in increments of 10 per
> each tic. When I set the scale to logarithmic, the only two tic values left
> appearing on the axis are 10 and 100. How do I get the values 10, 20, 30,
> ..., 100 all to appear on the axis?
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1