I am creating a line graph in which the 2 series have different number of data points. Excel automatically plots the larger number of data points against the x-axis but I want to have it plot against the y-axis. Is there a way to swap the y-axis for the x-axis in Excel 2007?
Thanks
Thanks