Excel

Resolved · Low Priority · Version Standard

Mon 10 Mar 2008, 16:21 Delegate Zeenit said...

Zeenit has attended:
Visio Advanced course
Visio Introduction course

Excel

What is the best way to create graphs in excel.

Tue 18 Mar 2008, 08:51 Trainer Pete said...

RE: Excel

Hi Zeenit,
Thank you for your post, In response to your question, the easiest way to create a graph (chart) in Excel is to select the range you wish to have represented including any headers and then press the F11 (Function 11) key on the keyboard. This will create a basic chart on a new sheet, you can then use the Chart Menu option to change and format your chart. If you want to have the chart on the same worksheet as the data, select the data and then click the Chart button on the Standard Toolbar, Follow the steps offered by the Chart Wizard and create your chart. I hope that helps. Best regards Pete.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Visio tip:

Creating an organisation chart in Visio using Excel data

A quick and easy way to create an organisation chart by importing names and titles stored in list format in an Excel spreadsheet into Visio.

1. Select File, New, Organization Chart.

2. Start the Organization Chart Wizard.

3. At the first step of the wizard, select the 'Information that I enter using the wizard' option, and click Next.

4. At the second step of the wizard, select Excel, then type the name of the file.

5. Select Browse to choose the location you wish to save the file to, click Save, and then click Next.

6. Click OK - a Microsoft Office Excel workbook will open with column headings already entered for you.

7. Replace the sample text with the text you wish to appear in your organisation chart. By holding your cursor over each column heading, you should be able to view data entry tips.

8. Save the Excel file, then close Excel.

9. Proceed through the remaining steps in the wizard to create your organization chart from the data you entered into the Excel file.

Visio's organisation chart wizard will also recognise the following file formats (besides .xls):

- Microsoft Exchange Server Directory (Microsoft Exchange e-mail Address Book).

- Tab- or Comma-delimited text (.txt).

- Org Plus (.txt).

- Microsoft Office Access (.mdb) or any other file format for a database created in an Open Database Connectivity (ODBC)-compliant database application.