One way to represent c.i.s is to use type: stock chart, sub type: the
one that plots high-low-close.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
How can I make a confidence interval graph in Excel?