Y axis broken graph

[javedcse]

Hi All,
I am having a problem to draw a broken graph. The values of for Y axis are 0.4 to 300. If i want to show the smaller values
clearly in the graph what can i do. I found the link http://peltiertech.com/WordPress/bro...n-excel-chart/ that they do it by using broken graph but they did say anything about how to draw broken graph. can anyone please help me to do fix it out it.

[Steve=True]

Hello Javedcse,

Welcome to the forums.

AndyPope has a good tutorial on this topic located here:

http://www.andypope.info/ngs/ng7.htm


That being said, this technique should be used with EXTREME caution. The reason being as Jon posted in his blog, they are very misleading because they misrepresnt the sizes of the data.

Good luck

Steve=True

[javedcse]

If my graph is a cluster column graph how can i break line?


Regards,
Javed