Bar chart with numbers inside that aren't the value

[Mackers]

Hi

I have some data that I want to display in several side-by-side bar charts. Example data is pasted below.

I want the chart to have a count up the 'y' axis and years 1 to 5 on the 'x' axis, so there are five side-by-side bars of equal height going up to 20,000. The bar should be divided into twenty sections, one from 0 to 1,000, the next from 1,000 to 2,000 and so on up to 19,000 to 20,000. Each section needs to contain a number, so from 0 to 1,000 the number £50 should appear in year 1, £55 in year 2 and so on.

Is this possible?

Thanks in advance

Mackers

[TABLE="width: 384"]
<tbody>[TR]
[TD]Count
[/TD]
[TD]Year 1
[/TD]
[TD]Year 2
[/TD]
[TD]Year 3
[/TD]
[TD]Year 4
[/TD]
[TD]Year 5
[/TD]
[/TR]
[TR]
[TD]1,000
[/TD]
[TD]£50
[/TD]
[TD]£55
[/TD]
[TD]£60
[/TD]
[TD]£65
[/TD]
[TD]£70
[/TD]
[/TR]
[TR]
[TD]2,000
[/TD]
[TD]£47
[/TD]
[TD]£52
[/TD]
[TD]£57
[/TD]
[TD]£62
[/TD]
[TD]£67
[/TD]
[/TR]
[TR]
[TD]3,000
[/TD]
[TD]£44
[/TD]
[TD]£49
[/TD]
[TD]£54
[/TD]
[TD]£59
[/TD]
[TD]£64
[/TD]
[/TR]
[TR]
[TD]4,000
[/TD]
[TD]£41
[/TD]
[TD]£46
[/TD]
[TD]£51
[/TD]
[TD]£56
[/TD]
[TD]£61
[/TD]
[/TR]
[TR]
[TD]5,000
[/TD]
[TD]£38
[/TD]
[TD]£43
[/TD]
[TD]£48
[/TD]
[TD]£53
[/TD]
[TD]£58
[/TD]
[/TR]
[TR]
[TD]6,000
[/TD]
[TD]£37
[/TD]
[TD]£40
[/TD]
[TD]£45
[/TD]
[TD]£50
[/TD]
[TD]£55
[/TD]
[/TR]
[TR]
[TD]7,000
[/TD]
[TD]£36
[/TD]
[TD]£39
[/TD]
[TD]£44
[/TD]
[TD]£49
[/TD]
[TD]£52
[/TD]
[/TR]
[TR]
[TD]8,000
[/TD]
[TD]£35
[/TD]
[TD]£38
[/TD]
[TD]£43
[/TD]
[TD]£48
[/TD]
[TD]£49
[/TD]
[/TR]
[TR]
[TD]9,000
[/TD]
[TD]£34
[/TD]
[TD]£37
[/TD]
[TD]£42
[/TD]
[TD]£47
[/TD]
[TD]£46
[/TD]
[/TR]
[TR]
[TD]10,000
[/TD]
[TD]£33
[/TD]
[TD]£36
[/TD]
[TD]£41
[/TD]
[TD]£46
[/TD]
[TD]£43
[/TD]
[/TR]
[TR]
[TD]11,000
[/TD]
[TD]£33
[/TD]
[TD]£35
[/TD]
[TD]£40
[/TD]
[TD]£45
[/TD]
[TD]£40
[/TD]
[/TR]
[TR]
[TD]12,000
[/TD]
[TD]£33
[/TD]
[TD]£34
[/TD]
[TD]£39
[/TD]
[TD]£44
[/TD]
[TD]£37
[/TD]
[/TR]
[TR]
[TD]13,000
[/TD]
[TD]£32
[/TD]
[TD]£33
[/TD]
[TD]£38
[/TD]
[TD]£43
[/TD]
[TD]£34
[/TD]
[/TR]
[TR]
[TD]14,000
[/TD]
[TD]£32
[/TD]
[TD]£32
[/TD]
[TD]£37
[/TD]
[TD]£42
[/TD]
[TD]£31
[/TD]
[/TR]
[TR]
[TD]15,000
[/TD]
[TD]£32
[/TD]
[TD]£31
[/TD]
[TD]£36
[/TD]
[TD]£41
[/TD]
[TD]£28
[/TD]
[/TR]
[TR]
[TD]16,000
[/TD]
[TD]£31
[/TD]
[TD]£30
[/TD]
[TD]£35
[/TD]
[TD]£40
[/TD]
[TD]£25
[/TD]
[/TR]
[TR]
[TD]17,000
[/TD]
[TD]£31
[/TD]
[TD]£29
[/TD]
[TD]£34
[/TD]
[TD]£39
[/TD]
[TD]£22
[/TD]
[/TR]
[TR]
[TD]18,000
[/TD]
[TD]£31
[/TD]
[TD]£28
[/TD]
[TD]£33
[/TD]
[TD]£38
[/TD]
[TD]£19
[/TD]
[/TR]
[TR]
[TD]19,000
[/TD]
[TD]£30
[/TD]
[TD]£27
[/TD]
[TD]£32
[/TD]
[TD]£37
[/TD]
[TD]£16
[/TD]
[/TR]
[TR]
[TD]20,000
[/TD]
[TD]£30
[/TD]
[TD]£26
[/TD]
[TD]£31
[/TD]
[TD]£36
[/TD]
[TD]£13
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Mackers]

Ah I managed to do it using data labels set to a range. Thanks for anyone that looked at this