Results 1 to 7 of 7

Link Chart Name to Cell Value

Threaded View

  1. #1
    Registered User
    Join Date
    11-20-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    29

    Link Chart Name to Cell Value

    Hey guys. I am trying to get familiar with VBA and I got stuck on this problem. I have a macro that will insert a line of data on sheet1, and then make a graph of that data on sheet2. However, when I run this macro a second time I get an error regarding the name of the second chart it created. Long story short: I need a way to use a value from the row a created as a name for the new chart. Despite much searching, I have only been able to find a way link a cell value to a chart title, not the name.

    I am currently using:

    ActiveChart.Parent.Name = "Chart Title"

    But I need for every chart to have a unique name and I cannot find a way to:

    ActiveChart.Parent.Name = "cell value". I have tried ActiveChart.Parent.Name = "=Bills!$A$3" as a test, but (as I am sure you know) it named the chart '=Bills!$A$3'.

    Thanks for all the advice!
    Last edited by exceln00b22; 01-20-2013 at 01:35 PM. Reason: Solved!

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