samedi 18 avril 2015

Excel multiple dynamic graphs

I have a series of data which I'd like to plot into a few graphs. The data is ordered by date and extracted data tagged with a TRUE condition next to it based on prior conditions.


As there is a large data set, is it possible to generate a series of graphs automatically? I know how to create macros using the record macro function, just that I'm unsure how to filter the data to make the graphs.


In the sample data below, I would have 2 graphs with date ranges 1-3 Jan and another from 6-7 Jan.


Thanks in advance!


Eg:


T/F Date Data


True 1-Jan 0.1


True 2-Jan 0.2


True 3-Jan 0.4


False 4-Jan 0.2


False 5-Jan 0.1


True 6-Jan 0.3


True 7-Jan 0.4


Aucun commentaire:

Enregistrer un commentaire