+ Reply to Thread
Results 1 to 3 of 3

Chart/Line Graph HELP!

  1. #1
    Registered User
    Join Date
    06-14-2011
    Location
    sf bay area, CA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Chart/Line Graph HELP!

    I want to display a line with 10 tick marks at equally distributed points and then place a marker a one point.

    Scale = 50 to 100

    Sample:
    Line from 55 - 82
    Tick Marks at 55, 58, 61, 64, 67, 70, 73, 76, 79 and 82
    Marker at 60

    Anyone know how to do this?

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Chart/Line Graph HELP!

    Hi
    what kind of marker do you want at value 60 - something like the attached?
    Attached Files Attached Files

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Chart/Line Graph HELP!

    Anything we can provide will be guesswork, unless you post your data and the chart you have developed so far in an Excel file.

    What axis are you talking about? X or Y?

    Based on the chart posted by NickyC, change the Y axis and set minimum to 55, maximum to 83 and Major Unit to 3. That will produce the Y axis labels according to your description.

    If that's not what you want, please upload a sample file with your data. Use the drawing tools to mock up a chart, so we know what to aim for.

    cheers,

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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