Excel 2007 can create a range of graphs and charts based on data in your spreadsheet, including line, column, area, line, pie, scatter, and bar charts.
Once created, Excel graphs will automatically update to represent any changes in data that you may make.
Before we start you’ll need a set of data so that you can give Excel something to make a graph out of. Copy the data shown below, or use something similar that’s relevant to you.
Using this example, highlight cells A5 to D8, i.e. all the information in the table apart from the total sales and the title. After you have highlighted the cells, click on the insert tab at the top of the ribbon which will give you a range of graph and chart options – select “column chart”. You will now be presented with a list of column charts to choose from, select the “Clustered chart”; this is the first one in the list under the 2D section.
The following basic graph will appear containing the relevant information:
Read more
Posted by Alistair Wylie in Excel Training on May 6th, 2009 | No Comments »
The default size and position of the chart that Excel has created will not neccesarily suit your requirements.
When you select a chart in Excel 2007, handles will appear around the outline. to change the size of the chart, hover your mouse over one of these handles until your pointer turns into a multi-directional arrow. Now press and hold the left mouse button and drag to make the chart bigger or smaller.
You can also move the chart. Simply click and hold while your cursor is over a blank section of the chart and drag the chart to whatever position you prefer.
Read more
Posted by Alistair Wylie in Excel Training on May 6th, 2009 | No Comments »
You may want your chart to appear on its own worksheet within your workbook. To do this open the chart options ribbon by clicking on your graph. Along with the options you have already used earlier, i.e. chart styles; there is an option on the right called the “move chart location” – click on this:
You will now be asked whether you want to move the chart to another worksheet that already exists, or to a brand new chart sheet.
A worksheet is the default sheet format that Excel works from (the sheet that you are currently working from is a standard worksheet). If you choose to move your chart to another worksheet you will have to choose which one you want to send it to, i.e. worksheet 2 or 3.
Tip: These other worksheets are available through tabs at the bottom left hand corner of your current work sheet.
Once you have mastered these skills you will be ready to attend our Advanced Excel Course, and really advanced might want to try VBA for Excel in Brighton, Sussex.
Read more
Posted by Alistair Wylie in Excel Training on May 6th, 2009 | No Comments »
