Changing Graph Data Series

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have about 12 graphs each with 4 data sets that I have to change the
data set range on each month to display the next months data as it is
accumulated through the month. This is a very time consuming task.
Is there a way to set the data range to key off of a formula (using
current month and a vlookup for example) or off of a range supplied
from key input cells?

Ultimately I would like to be able to specify a data range (from jan1
through Dec 31) and have the graph update the data series for the
range and display. But for now I'll settle on a faster method to
change the data range each month.

Any ideas?

Duey

.

Relevant Pages

  • Re: Tools for GUI/graphics
    ... graphs as .JPG files and display them in a ... generating graphs from data, ... Chart Director is a product I have a little experience with which has Python ... it has a very liberal demo policy: demo versions display a small ...
    (comp.lang.python)
  • Re: Viewing multiple .png files simultaneously
    ... display those graphs in 4 individual X-windows as soon as the data ... from ImageMagick to make a single image that contains the ... `- GPG Public Key: 0x25BFB848 Please GPG sign your mail. ...
    (comp.os.linux.development.apps)
  • Re: Viewing multiple .png files simultaneously
    ... display those graphs in 4 individual X-windows as soon as the data ... if what you actually need is 4 PNG images ... for example be a web browser. ...
    (comp.os.linux.development.apps)
  • Using OWC.Chart control in asp
    ... display line graphs in my application. ... even older versions (Excell 97) won't display the graph. ... chConstants.chDataLiteral, aiSeries1 ...
    (microsoft.public.office.developer.web.components)