Have you ever felt the sudden need to use graphs while auditing an excel model?
Sometimes while auditing a model I find the need to have graphical support to evaluate the data.For this I must create a chart.
For example if I am looking at the profit and loss sheet of my model and I want to evaluate it over 5 financial years. It is easier to do this graphically. But I cannot be creating manual charts everytime.
For this I have a shortcut for automatic charts generation.
I suggest you use shortcuts
Though I am not very sure about the shortcut.
You can try F11
How is this useful?
I can generate a general chart on the data I am auditing. This does not require any manual data selection.