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

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

<tbody>
</tbody>

 

[Mackers]

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