+ Reply to Thread
Results 1 to 3 of 3

Can't create lines that passes through a particular data point

  1. #1
    Registered User
    Join Date
    04-11-2016
    Location
    Brisbane
    MS-Off Ver
    2010
    Posts
    40

    Can't create lines that passes through a particular data point

    Hi guys,

    This is a very simple question that I'm sure most of you will be able to help me out.

    Referring to the spreadsheet I sent you, you'll see a yellow box highlighting the values of the OMC and MDD. I tried plotting those two data points on the graph and the point comes out to be really small in comparison to the other OMC data point (highlighted in red). How do I make it larger and why is it doing that?

    Also, for the OMC/MDD data point, how do I create a vertical and horizontal dashed line that meets the OMC/MDD data point?

    Thanks guys. Your help will be much appreciated.
    Attached Files Attached Files

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

    Re: Can't create lines that passes through a particular data point

    I tried plotting those two data points on the graph and the point comes out to be really small in comparison to the other OMC data point (highlighted in red). How do I make it larger and why is it doing that?
    If I understand correctly, it is because of Excel's "automatic" choice for these data series' markers. It is automatically choosing the little "tick mark" markers, which appear smaller than the other markers. This should be easily changed by going into the "format data series" dialog and changing the marker options from "automatic" to whatever marker you want to use. https://support.office.com/en-us/art...1-363fad4c60fd

    how do I create a vertical and horizontal dashed line that meets the OMC/MDD data point?
    The usual strategy is to add negative error bars to this point and format them as desired (-100% and formatted as dashed lines). https://support.office.com/en-us/art...5-864049a145f0
    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
    04-11-2016
    Location
    Brisbane
    MS-Off Ver
    2010
    Posts
    40

    Re: Can't create lines that passes through a particular data point

    Thank you again, you solved my problem once again!

+ 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. Formulas for calculating for two sma lines crossing point value
    By DavidRoger in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-28-2015, 05:13 AM
  2. Trying to create invidiual chart reports for many lines of excel data
    By gina40girl in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-18-2013, 12:32 AM
  3. [SOLVED] Help, trying to create macro to add lines to current data
    By kenadams378 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-24-2012, 10:06 AM
  4. Replies: 0
    Last Post: 07-11-2012, 05:51 AM
  5. Replies: 2
    Last Post: 06-27-2011, 10:47 PM
  6. create lines with copied data for every count in a table
    By barri in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2010, 09:43 AM
  7. [SOLVED] Finding the value for the point two lines cross
    By Brian in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-02-2006, 08:10 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