Once you have done this, type the following text to create the custom function.
Step 2 Now the function is written we can switch back to the worksheet.
Therefore we created a ‘best practice’ project management template which automatically creates a pretty GANTT chart for you.Or you can manually adjust the axis scales; when the charted values change, you must manually readjust the scales. We can use the has appeared automatically atop the module. Wouldn’t it be great to be able to link the axis scale parameters to values or, even better, formulas in the worksheet? If you want a ready-to-use solution, try Tushar Mehta’s Auto Chart Manager add-in, available as a free download at You can write the entire procedure yourself, but it’s easier and more reliable to let the VB Editor start it for you. Please do provide feedback on my articles, or whether you know of a easier way to do this. You can let Excel scale the axes automatically; when the charted values change, Excel updates the scales the way it thinks they fit best. Or you could assign the code to a button in the worksheet. A more elegant approach is to change the relevant axis when one of the cells within B14: C16 changes.