Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2005
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Replacing reference series in Excel charts (XP 2003, SP2)

    I would appreciate help with the following. I have a large number of charts that show 2005 and 2006 actual data + 2006 forecast. This year, I need to change the charts so that they show 2006 and 2007 actual data + 2007 forecast. In other words, if the chart reference for actual weekly sales was: $D$220:$D$323 now it has to be changed to $D$272:$D$375. I tried to record a macro to do this but all it does is automatically create one chart with a set reference and I do not know enough VB to create a routine that goes through a chart and changes the cell references. Again, your help is greatly appreciated and have a happy New Year. Thanks - Altin.

  2. #2
    Lounger
    Join Date
    Mar 2005
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replacing reference series in Excel charts (XP

    Ok, I am responding to my own post but I just noted that that FlexFind (add-in) does address this. First I thought about deleting the post but maybe someone else may have come acoss this issue and could find it of interest. Thanks, Altin

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replacing reference series in Excel charts (XP

    Thanks for letting us know.

    Flexfind may be found here.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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