Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have an XY chart I'd like to add a vertical and a horizontal line at the mean of each series. I can get a horizontal line on the chart. The scale isn't quite right because it doesn't go all the way across the chart. However, I'm stumped at how to get the vertical line on. I have a lot of these charts to do, so I need to be able to use the charting tools and not draw lines on the chart.

    Finally, I'd like to add labels to each with the labels A - N, not the values. I vaguely remember having an add-in that did this, but can't find the reference to it.

    Thanks for your help.

    Cathy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The add-in is Rob Bovey's XY Chart Labeler.

    You mention "a vertical and a horizontal line at the mean of each series" - do you mean (pun) the mean of the x-values and the mean of the y-values? You can do this by defining extra series.
    To make the lines go all the way across the chart, you have to set the minimum and maximum values of the axes instead of leaving it to Excel.

    See the attached workbook. (I haven't added data labels)

    [attachment=86379:ScatterChart.xls]

    Attached Files Attached Files

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts
    This is exactly what I need. As always, you rock! Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •