My imagination is flying right now...
- with six measures and a week column
- and last year as columns
- my week column should be on the x axis
- I have all the metrics as columns in my data feed
In short, upload an example please using superstore data if you can, I have no idea what you are looking for right now.
I'm thinking you need to add a column (I know, I know) so that your stacked bars are represented side by side, but it appears from your description above that the columns fields are already quite congested.
I would want to represent all the six metrics in one graph. All the six metrics are six columns in my feed. Any other alternate visualization which can achieve this will also be good.
I believe you have specific reason to seek this, but I personally think.
It's too much complicated view and quite difficult to read.
At the same time, it requires very complicated workaround to build.
So I hesitate to challenge and don't recommend to chase this option.
Just flagging some of the issues with this viz
Between 1 and 2 the lines are attempting to share the same space as 2 columns (4). Unless there are separate values for each column of data this will not be possible. It does not appear (in your pic) that the lower value in 2 has an independent value kind of like what is shown in 3.
As Shin indicated, this is a complex view, and you will be using a double-axis on both the X and Y.
If you want to go this route (and I don’t recommend that you do) given your data source you’ll need to pivot it and then write some calculations. See http://drawingwithnumbers.artisart.org/bars-and-lines for details.
Sent from my iPhone