I have been viewing this thread:
http://www.excelforum.com/excel-char...03#post3368203

and:

http://peltiertech.com/Excel/Charts/StackedCharts.html

I am using excel 2010.

I would like to make a stacked plot capable of showing gaps in a line graph/x, y scatter. So if data is missing there is literally a gap in the line instead of interpolation.

I have used the peltiertech site up to the point of secondary axes but I can't get that part to work using those instructions. Does anyone know if I can:

A - Do the same a different way in 2010 version and

B - Create gaps where data is missing

Thanks