Results 1 to 2 of 2

Naming Series Problem

Threaded View

  1. #1
    Registered User
    Join Date
    01-21-2011
    Location
    Mars
    MS-Off Ver
    Excel 2007
    Posts
    7

    Naming Series Problem

    When I run this code, it doesn't name the series to what I want (Chart Name), it just calls it the default "Series 1". How do i fix this problem?

        With ActiveSheet.ChartObjects.Add _
                (Left:=100, Width:=375, Top:=75, Height:=225)
            .Chart.SetSourceData Source:=Sheets("Run Data (9 blade)").Range("B3:B15,D3:D15")
            .Chart.ChartType = xlXYScatterLines
            .Name = "Chart Name" 
            .Chart.Location Where:=xlLocationAsNewSheet
        End With
    Last edited by fugima; 02-01-2011 at 10:45 AM.

Thread Information

Users Browsing this Thread

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

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