Results 1 to 2 of 2

Thread: Mschart Control

  1. #1
    Join Date
    Apr 2003
    Posts
    5

    Unanswered: Mschart Control

    Can anybody help me in showing the values on top of the bar . I am using MSCHART

    For example in Excel the following will display the values on top of the bar
    ActiveChart.ApplyDataLabels Type:=xlDataLabelsShowValue

  2. #2
    Join Date
    Sep 2003
    Location
    india
    Posts
    4

    Labeling the MSChart Control

    Hi, dude


    You can copy this piece of code after loading your code


    With MSChart1
    Set .DataSource = rs
    For i = 1 To .Plot.SeriesCollection.Count
    With .Plot.SeriesCollection(i).DataPoints(-1).DataPointLabel
    .LocationType = VtChLabelLocationTypeOutside
    .Component = VtChLabelComponentPercent
    .PercentFormat = "0%"
    .VtFont.Size = 12
    End With
    Next i
    End With



    hope it works, just make the necessary changes.

Posting Permissions

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