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!

Register Yourself Login