98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel-xp-training - Graphs
excel-xp-training - Graphs
Resolved · Low Priority · Version Standard
RE: Graphs
Hi Chris,
Thanks for your question.
Two ways to create a graph:
A. If you are not too fuss about location / graph type:
1 - Select data table (i.e. labels & numbers) on worksheet
2 - Press F11 (by default, it creates a 2D column chart on a new sheet)
B. Use Chart Wizards:
1 - Select data table (i.e. labels & numbers) on worksheet
2 - Click on INSERT menu > Chart
3 - Go through the 4 steps to select Chart Type, set up labes / axis / gridlines / legend and location.
4 - press ok
Hope this helps.
Regards,
Katie
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Repeat actionThe F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again. |