Thank you. That is originally how I started to create the chart. I copied the data to a file and generated a macro. I wasn't sure how to call the macro since it would be specific to that worksheet and I have numerous files that will be created (based on various criteria), so I didn't think that would work. However, you made it seem quite simple - I don't know if I have time to go back and 'un-do' everything I've done. It's good to know for future reference though!

Happy New Year!