Selecting certain pieces of data from query

[ajc5382]

Hello,

I have a program written that pulls info from an online data warehouse. With this data, I calculate correlations and volatilities.

Here is my dilemma, I need to be able to go through this data and put certain blocks of calculations in specific graphs. For example, say I have calculations from 2008 to present. How can I have a graph set for each years calculations (2008, 09,...) without separately re-running data pulls for 2008 present, 09 to present, 10 to present, etc...

Any help would be huge!

[dangelor]

Have you looked into Pivot Table Charts?

[ajc5382]

I actually had a quant quickly show me how to do what I was looking to do. The only problem now is, how do i get past blank spaces in my data when doing calculations such percent differences, weighted averages, etc etc. Obviously when doing something like a percent difference, dividing by 0 will result in an error. A quant I know suggested using a do while loop with the isempty function. What do you think?