how can I modify the axis to show a wide range of value e.g. from.

[YSL]

I am trying to display values ranging from 195 to 2.5 on the same chart, thus
might have to break the axis in the middle, but not sure how to use Excel to
do that. Any suggestion?

 

[Andy Pope]

Hi,

For information on creating a chart with a broken y axis have an look at
Jon's example, which includes links to other approaches.
http://peltiertech.com/Excel/Charts/BrokenYAxis.html

Cheers
Andy

 

[Tushar Mehta]

Also check the response(s) to your duplicate post(s) on the subject.

--
Regards,

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