Results 1 to 13 of 13

Adding median lines to xy scatter graph

Threaded View

  1. #1
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Adding median lines to xy scatter graph

    Hi,

    This is probably one for Andy, but ideas welcome from all.

    I have two sets of data (i.e. several rows and two columns), both with values in the range 0 - 1. I'm plotting these on an xy scatter chart

    The two median values for these two sets of data now need to be plotted on the chart as two lines, one horizontal and one vertical, effectively dividing the chart into 4 quadrants.

    At the moment I've been achieving this functionality somewhat artificially, by superimposing 4 rectangle objects on the chart and adjusting their dimensions manually to coincide with the two median values on the two axes.

    In addition I've been manually adding two text boxes each containing one of the median values and positioning it next to the appropriate median 'line'.

    My question is this.

    Is there a neater way of achieving this functionality without the somewhat artificial method of resorting to overlaid rectangles?

    I can adjust the 4 rectangles programatically by changing the height and width property, but the text box needs to be positioned and there doesn't appear to be a Top and Left property.


    All ideas gratefully received. Usual TIA
    Last edited by Richard Buttrey; 10-26-2008 at 08:14 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Broken Lines on my Scatter Graph
    By chrismann85 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-22-2008, 05:18 AM
  2. Labelling individual points on a scatter graph
    By Amethyst in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-02-2007, 02:57 AM
  3. Scatter Graph with Trendline and Trend band!
    By ssrirao in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 05-23-2007, 04:14 AM
  4. Plotting points on a scatter graph
    By Hodged in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-04-2007, 07:36 AM
  5. 3D scatter graph i.e X, Y, Z, scatter graph
    By SuperNomad in forum Excel General
    Replies: 3
    Last Post: 03-27-2007, 03: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