Cut X axis

[Francisco]

Bom dia = Good morning

I need to know, how can i put a variable like "A3" the value of de chart cut
de X axis.

Obrigado = Thanks

 

[Jon Peltier]

Francisco -

Something like this, which is shown for the Y axis, but would work for
any axis:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Andy Pope]

Hi Francisco,

A slightly different interpretation to Jon's.

Try Tushar's addin, which links the axis maximum value to a cell.
http://tushar-mehta.com/excel/software/autochart/index.html

Cheers
Andy

 

[Jon Peltier]

This one has lots of room for interpretation. <g>

- Jon