Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - Creating graphs

excel consultants - Creating graphs

ResolvedVersion Standard

Tue 21 Aug 2007, 09:51 Delegate Amina said...

Amina has attended:
Excel Intermediate course

Creating graphs

How would you create a graph

Wed 22 Aug 2007, 05:21 Trainer Tracy said...

RE: Creating graphs

Hi Amina,

Thanks for the question.

You can create a chart by putting your active cursor in the data you wish to convert to a graph and using the chart wizard. This is a button on your toolbar which looks like a miniture chart. Here you have a four stage procedure where at each stage you can change the settings of your chart until you are happy with it and you press "finish". Alternatively pressing F11 will also create a standard graph.

Tracy

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips

excel consultants - Creating graphs

Creating graphs

RE: Creating graphs

Excel articles

Excel tip:

Convert a column into row quickly in Excel 2010