Results 1 to 10 of 10

Thread: Macro code to turn a graph from linked to a series - RESOLVED

Threaded View

  1. Oct 24th, 2006, 06:41 AM #1
    strobinson1
    strobinson1 is offline

    Thread Starter
    Addicted Member
    Join Date
    Sep 2004
    Location
    Surrey, UK
    Posts
    163

    Macro code to turn a graph from linked to a series - RESOLVED

    If you have a graph that is linked to a specific data range,

    if you highlight the series on the graph, click in the formula bar, and hit F9....

    The series changes from being references to a set of cells to the actual values. a bit like a paste special...values for a graph.


    Does anyone know a way of coding this procedure into a macro ??????????
    Last edited by strobinson1; Mar 8th, 2007 at 04:30 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width