Results 1 to 15 of 15

Logarithmic Chart with Additional Y Axis

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2019
    Location
    England
    MS-Off Ver
    MAC 16.16.1
    Posts
    9

    Logarithmic Chart with Additional Y Axis

    Hello All,
    I am trying to create a logarithmic chart in Excel with a data set which I have done here:
    Screenshot 2019-11-13 at 11.15.32.png

    However as you can see there are only lines visible at the major data point nodes. What i'd like to do is make the Y Axis lines on the chart look a bit more like this:
    Screenshot 2019-11-13 at 11.18.13.png

    As you can see, there are a lot more lines spanning the Y Axis so it would be easier to read the data off the chart.

    I have tried a few different ways of playing around with the base and then the major and minor bounds but can't seem to get anything to look like the second image.

    Any help would be appreciated,
    Thank you!

    Example Sheet: Example Sheet.xlsx
    Last edited by lewisnewson; 11-13-2019 at 10:27 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Chart with not-quite logarithmic axis spacing (example attached)
    By Buckzor in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-17-2017, 11:17 AM
  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. Bubble chart with additional Y axis values
    By Neffy812 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-03-2011, 07:24 AM
  4. Difficulty with Additional Y-axis value on excel chart
    By excelman1984 in forum Excel General
    Replies: 3
    Last Post: 09-11-2011, 06:55 PM
  5. 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
  6. [SOLVED] How do I add an additional X axis in a chart
    By Jollybox in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-17-2005, 07:06 PM
  7. how can I make a chart with the x-axis in logarithmic scale
    By Doris in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-17-2005, 12:06 PM

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