vba-excel-training - Charts 2007

The UK's most regular instructor-led training courses.
Training information: vba-excel-training · Excel in courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Charts 2007

Owen has attended:
Excel Introduction course

by - delegate Owen [1 post] (2007 Nov 12 Mon, 16:53) Reply

how do i make make my charts look professional?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: charts 2007

by - trainer Amanda diamond contributer [1297 posts] (2007 Nov 29 Thu, 16:20) Reply

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

· Features of Microsoft Excel that assist in Analysis of Financial Data
· Benefits of learning about Excel charts
· Customized Financial Excel Courses in London
· Reporting and Analysis with Excel
· Excel in the Home Office

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

Rate this page: