Hoping for some advice here. I've designed a stacked bar chart where each dimension totals 100% using a basic inline table for development purposes. I've now received the proper data set from the client (see extract below). The problem lies in the structure of the data, with each question as field, with the answers values within it, rather than having individual 'Question' and 'Answer' fields. Obviously, my stacked bar chart won't work in its current form (as it assumes the presence of two fields) and I'm now faced with scripting Excel to re-arrange the data into an appropriate structure OR (and I've got my fingers crossed) someone has any clever ideas on producing a stacked bar chart using the data in its current format (headings refer to question and remaining values are the answers)?