That works if you want to put one series of data on the secondary axis. I would like to put 3 series of data but for only one time period on the secondary axis. Any way to do that?
Is there a way to create a column chart in excel with 2 axes? I have my data by month but also need to have YTD data at the end. The value of the YTD data will be much larger than my monthly data. I do not want to have to have a huge scale to accomodate the YTD data, thus wanting to use 2 axes...