+ Reply to Thread
Results 1 to 2 of 2

Recorded Macro changes to chart name issues

  1. #1
    Registered User
    Join Date
    07-02-2013
    Location
    naperville
    MS-Off Ver
    Excel 2010
    Posts
    10

    Recorded Macro changes to chart name issues

    I have this recorded macro that selects a chart (named "Chart 1") that is on a worksheet and changes the name of the title. Worked fine until I decided to put the chart on an acual chart sheet and not a worksheet that show the grids.

    So the naming convention of the chart changed and the macro didnt work. So I named the new chart "Northing" (which actually automatically named the sheet Northing, I guess since its a chart sheet and not a worksheet?). I debugged the original recorded macro and simply changed all the names from "Chart 1" to "Northing." Did not work.

    It did not recognize my new name. I don't get it.

    Original chart macro that worked under a worksheet....

    Sheets("Northing").Select
    Active.ChartObjects("Chart 1").Activate
    ActiveChart.ChartTitle.Select
    ActiveSheet.ChartObjects("Northing").Activate
    ActiveChart.ChartTitle.Text = "Soil Nail Wall Northing" & Chr(13) & "All Sensors"
    Sheets("Easting ").Select

    Modified macro that did not work

    Sheets("Northing").Select
    Active.ChartObjects("Northing").Activate
    ActiveChart.ChartTitle.Select
    ActiveSheet.ChartObjects("Northing").Activate
    ActiveChart.ChartTitle.Text = "Soil Nail Wall Northing" & Chr(13) & "All Sensors"
    Sheets("Easting ").Select

    Any suggestions?

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Recorded Macro changes to chart name issues

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Recorded Pivot Table Macro Doesn't Do What I Recorded!
    By diakonos1984 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2013, 11:01 AM
  2. [SOLVED] excel 2007 chart macro graphs data only from sheet on which macro was recorded
    By JW1028 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-19-2013, 06:33 PM
  3. [SOLVED] Having issues with a Macro to get Chart Data
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-05-2012, 06:52 PM
  4. recorded macro for chart has no x values
    By Leon V (AW) in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2011, 04:14 AM
  5. Creating a macro which presses a button containing a recorded macro
    By petros89 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2005, 10:05 AM

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