I have lots of datasets that I need to graph as lines on a 2-axis graph. However, some datasets are daily, weekly, monthly, quarterly, or annual. In the past I would simply grind through the low-resolution dataset (say, weekly) and insert 6 rows then repeat over and over until I matched. However, these new datasets are huge, and that is simply not realistic. I either need a way to (1) graph datasets with different sample rates by referring to their dates and having Excel understand to match them OR (2) create a macro that inserts 6 rows and repeats over and over. I cannot figure out how to do either. Can anyone help? Chuck