displaying data in an alternative format

[Simon L]

This might may be really simple but it has alas got me beaten. I have some sales data and I basically want to display it an alternative way in order to graph it as a stacked column chart. Have a look at the attached file which shows how the data is displayed at the moment (Current_Data tab) and how I want to show it (Displayed tab). Thanks in advance.

[mrice]

Try the attached. I've used a macro to reformat the data and adjust the range of the chart accordingly.

Just hit the GO button on the first sheet.

[Simon L]

great thanks....I'll have a look at the backend see how it all works.