Custom data point

  • If I check the box labeled catagory name on the intial creation or within chart options on the right click menu each data point gets labeled with the name of the catagory.
    I would like to label a significant event at one of these data points does anyone know how to do this? If this isn't a built in feature does anyone have a work around that would look good?


    Thanks
    Dave

  • Re: Custom data point


    This will replace the data marker with a text box that you can pre-format as you wish:

    Code
    Sub Dave()
        Range("A1").Select ' can't have the chart selected here
        ActiveSheet.Shapes("Text Box 1").Select
        Selection.Characters.Text = "Label" ' or value
        Selection.Copy
        ActiveSheet.ChartObjects("Chart 1").Activate
        ' compute the point of interest (4 here) and apply the label
        ActiveChart.SeriesCollection(1).Points(4).Paste
    End Sub
  • Re: Custom data point


    Howdy. It would help to include the data itself, and not just the graph.


    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt


    Old, slow, and confused - but at least I'm inconsistent!


    Rich
    (retired Excel 2003 user, 3.28.2008)

  • Re: Custom data point


    What do you mean by:


    Quote

    I would like to label a significant event at one of these data points?


    How do you determine which event/data point? Will it be based on values or will it change depending on your needs?


    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt


    Old, slow, and confused - but at least I'm inconsistent!


    Rich
    (retired Excel 2003 user, 3.28.2008)

  • Re: Custom data point


    Wow, I feel special! I was coming up with a solution, and it was the same as Andy's!!! Who would have ever imagined that??? :)


    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt


    Old, slow, and confused - but at least I'm inconsistent!


    Rich
    (retired Excel 2003 user, 3.28.2008)

  • Re: Custom data point


    You add a second column to the data source (Column C on Andy's). Put in the value you want (or formula referencing Col. B). Then when it is added to the chart, select that series, and for the format, select No line, and for the point, select the circle, with No fill. Change the size of the circle to suit your needs.


    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt


    Old, slow, and confused - but at least I'm inconsistent!


    Rich
    (retired Excel 2003 user, 3.28.2008)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!