I'm working on a VBA macro that will chart multiple series of data. How do I
tell the macro what range the series is on? I tried to do a record but that
gives me a static range.