excel advanced - data and charts
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel advanced - Data and charts

excel advanced - Data and charts

resolvedResolved · Low Priority · Version Standard

replyReply Wed 24 Jan 2007, 10:26Delegate Martin said...

Martin has attended:
Excel Intermediate course
Excel Introduction course

Data and charts

I would like to learn how to convert data input into a spreadsheet to charts on the same report.

I NEED TO PRODUCE REPORTS TO MY BOARD THAT WILL HAVE LOTS OF DATA ENTERED AND THEN SHOW THE DATA AIN THE FORM OF CHARTS AND GRAPHS

For upcoming training course dates see: Pricing & availability

replyReply Wed 24 Jan 2007, 13:37Trainer Richard said...

RE: data and charts

Hi Martin

Thanks for your question.

To create a chart/graph:

From your spreadsheet, select the data which contains the information you wish to graph.

Click the Chart Wizard button on the standard toolbar.

This will take you through 4 steps to create your chart. At the 4th step you can choose to display the chart on the same sheet as the spreadsheet data.

I hope this helps
Amanda

 


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard