+ Reply to Thread
Results 1 to 3 of 3

How to add extra axis labels in a logarithmic chart in Excel 2010?

  1. #1
    Registered User
    Join Date
    03-21-2015
    Location
    Milwaukee
    MS-Off Ver
    2010
    Posts
    16

    How to add extra axis labels in a logarithmic chart in Excel 2010?

    I need to add some additional vertical axis labels to a logarithmic chart in Excel 2010.
    You only get 1, 10, 100, 1000, etc. as standard.

    My data goes from 100 to 4000 and i would like to add 200, 500, and 2000 as additional axis labels.

    I apologize if the solution to this has been posted.
    I looked for it but could not find anything.
    Last edited by jerbes; 03-23-2020 at 01:55 PM. Reason: solved

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,783

    Re: How do I add extra axis labels in a logarithmic chart in Excel 2010?

    By faking your own axis instead of using Excel's built in axis: https://peltiertech.com/logarithmic-axis-scales/
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-21-2015
    Location
    Milwaukee
    MS-Off Ver
    2010
    Posts
    16

    Re: How do I add extra axis labels in a logarithmic chart in Excel 2010?

    Peltier's method is interesting, but WAY too complicated and excessive for what I need.

    After some searching, I found a much simpler method using the following steps to add additional axis labels to a logarithmic chart.

    1. Create your chart using your primary data. On my example, the vertical axis is logarithmic and the horizontal axis is dates.
    2. Create a small, two column "Axis Labels" table with either zeros or your smallest 'X' data value in the first column, and the values of the additional axis labels you need in the second (Y) column. This can get complicated. For example, if your X-axis is dates, and your smallest, left-most date is say Jan 1, 1940, then your 'X' value for that date in your "Axis Labels" table will have to be either "Jan 1 1940" or 14612.
    I wanted to add ten additional axis labels so my Axis Labels table looks like this. Since my smallest 'X' data value is Jan 1 1940, the 'X' values are all 14612;

    14612 200
    14612 300
    14612 400
    14612 500
    14612 700
    14612 1500
    14612 2000
    14612 2500
    14612 3000
    14612 4000

    3. Right-click on your chart > Select Data > Add a new series > call it "Axis Labels", and add the series X and Y values from your version of the above table.
    4. Move the mouse until you find one of your "Axis Labels" data points on the chart just outside (to the left) of the graph area, and right click. If you do this correctly, you can then see "Add Data Labels" and select it.
    5. Right-click on any one of the new axis labels > select "Format Data Labels" > and change the label position to Left. With luck the chart will look like this.
    6. You may need to go into "Format Data Series" and change Marker Options, Marker Fill, and Line Color to 'None or No'.

    Attachment 668705
    Last edited by jerbes; 03-23-2020 at 01:54 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Logarithmic Chart with Additional Y Axis
    By lewisnewson in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 11-13-2019, 02:05 PM
  2. [SOLVED] Problem with bar chart with logarithmic axis
    By ankit4035 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-09-2016, 08:40 AM
  3. [SOLVED] Axis & Legend Labels Missing when viewing from Excel 2010
    By Luisao82 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-10-2014, 04:49 AM
  4. Excel 2010 not displaying all X-axis labels
    By jo_b in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 06-21-2013, 09:23 AM
  5. Issue with Excel 2010 not displaying all X-axis labels
    By rjallison in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 12-15-2012, 07:49 AM
  6. Problems with axis labels text wrapping in Excel 2010 charts
    By PhunxZtar in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-27-2012, 08:29 AM
  7. Changing the x-axis values on a logarithmic chart?
    By c991257 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-30-2008, 07:18 AM

Tags for this Thread

Bookmarks

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