+ Reply to Thread
Results 1 to 4 of 4

Manually add fixed vertical horizontal line to chart

  1. #1
    Registered User
    Join Date
    11-24-2009
    Location
    Hull, England
    MS-Off Ver
    Excel 2003, 2007
    Posts
    32

    Manually add fixed vertical horizontal line to chart

    Hi I have a chart I wanted to plot data from 1 - 10 on both the x and y axis. This has worked but due to the size of the labels excel has made the range larger. I can hide all the intersecting lines most easily by making all the major grid-lines 100% transparent, but I needed to mark the half way point chopping my data plots into quarters.

    I need to add a horizontal line going all the way across the chart at 5 and a vertical line going all the way up the chart from 5.

    Do I really have to create a whole new series as an average and plot it to achieve this or can I just get excel to add them based on an intersection?

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

    Re: Manually add fixed vertical horizontal line to chart

    Hi datacruncher,

    you can do it all with grid lines and axis scale. See attached.

    Both axes are set to major interval 5 and minor 1
    grid lines are shown for both x and y axis and then formatted to be bold for major

    Of course you can take out some, if you feel it looks too much like nine men's morris!

    does that help any?

  3. #3
    Registered User
    Join Date
    09-22-2009
    Location
    Mumbai India
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    77

    Re: Manually add fixed vertical horizontal line to chart

    That is awesome, excellent and exactly what I'm after, many thanks!

    On a side note, is there any way I can add labels to each quarter section? I've built a relationship model plotting data from accounting info and it places a service sector in one of the quaters, ergo:

    Leverage, Strategic, Routine, Bottleneck. Just wondered if it would be possible to add a label into each quadrant on your chart?
    Last edited by smudgepost; 12-21-2009 at 08:10 AM.

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

    Re: Manually add fixed vertical horizontal line to chart

    Smudgepost, please don't ask questions in the thread of another member. I'll give you some leeway as a new member, but start your own threads for your own questions from now on, please.

    You can create text boxes with the drawing toolbar and position them on the quadrants. Other than that, I'd need to see your data.

    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