Organising chart data

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

Resolved · Urgent Priority · Version 2003

Simon has attended:
Dreamweaver 8 Introduction course

by - delegate Simon [23 posts] (2008 Apr 25 Fri, 12:50) Reply

I need to create a chart which shows each month of the year on the x-axis and value on the y. I need to show several years on the chart, with each year being a different colour. I'm not sure how to arrange the data to enable this - ie how can I get the Jan 05, Jan 06, Jan 07 & Jan 08, Feb 05, Feb 06 and so on to overlay on one chart using just 12 months along the x-axis? Grateful for your advice, thanks, Simon

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 15 Wed	Bloomsbury	0	FULL
2003	2008 Oct 15 Wed	Bloomsbury	0	FULL
2007	2008 Oct 15 Wed	Bloomsbury	0	FULL
2003	2008 Oct 17 Fri	Southwark	4	book now	£224	£235
2003	2008 Oct 22 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 22 Wed	Bayswater	5	book now	£195	£205
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Organising chart data

by - trainer Rich platinum contributer [718 posts] (2008 Apr 25 Fri, 22:44) Edited on 2008 Apr 25 Fri, 22:45 Reply

Hi

You need to columns, the first is date, the second is value. Add the chart and right click on a bar to format the data series. On the options tab select the 'Varies colour by point option' to make each bar a different colour. Please find attached an example.

regards