I don’t do a lot on Excel charts because there are already a number of excellent blogs and sites that specialise in that area; notably: Peltier Tech Blog
but after compiling my “Downloads by Category” page I found that I had lumped together some posts specifically about charts in with posts about drawing (i.e. using Excel shapes), which made them hard to find; so this post separates out all my charting posts from the past nearly five years:

• Automating chart scale limits
• Automating chart scale limits – update
• PView Function
• Charting a Mathematical Function with Defined Names
• When is an XY chart not an XY chart …?

Associated download files are:

• http://www.interactiveds.com.au/software/SetScale.xls
• http://interactiveds.com.au/software/IP2.ZIP
• http://interactiveds.com.au/software/PlotLS.xls
• http://interactiveds.com.au/software/Chart%20bug.xls