vba-excel-training - Charts 2007

Hi Owen

Thank you for your question, and apologies for the unusually long delay in response.

Excel 2007 makes it fairly simple to create professional looking charts.

Select the data you want to create the chart from, go to Insert, click Chart and select the type of chart you wish to create.

To add bits to the chart (e.g. title), make sure you have the chart selected then use the Layout tab under Chart Tools.

To change the colours used in the chart, make sure you have the chart selected then use the Design tab, go to the Chart Styles group and select a chart with different colours in it.

I hope this helps.
Amanda