Dynamic Charts

  • Im using the the offset/anyrange/counta method to alter a chart with dynamic ranges. However I need 2 sets of data graphed (producting 2 lines on the same graph). The good thing is one unique id will identify both sets of info (eg The word Times will id 2 sets of independant data. Not sure which way to go on this... thanks

  • not exactly sure what your problem / question is....


    I have graphs with 5 sets of dynamic lines on them each....

    just set up each line's graph data as it's own seperate dynamic range and add each as it's own series

    so maybe "xtimes1" with it's own dynamic range setup, entered as series1 and "xtimes2" with it's own dynamic range setup, entered as series2

    am I missing your problem ?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!