I have an Excel file containing multiple series of data(in rows, one row for a series only), and each of the series has different headers and length of data.
With such a structure of data, how should I chart all series with a horizontal stacked bar having headers on corresponding bars as shown like the image below?
Currently, I have to put headers on one by one using separate textboxes.![83291 83291](https://chandoo.org/forum/data/attachments/83/83383-458583cac74422c22c007abeb3120d11.jpg)
With such a structure of data, how should I chart all series with a horizontal stacked bar having headers on corresponding bars as shown like the image below?
Currently, I have to put headers on one by one using separate textboxes.
![83291 83291](https://chandoo.org/forum/data/attachments/83/83383-458583cac74422c22c007abeb3120d11.jpg)