Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Been working at this for awhile can anyone help me convert this data?:
Reporting Month | Jan-16 | Feb-16 | Mar-16 | Apr-16 | May-16 | Jun-16 | Jul-16 | Aug-16 |
Group1 | 50 | 65 | 97 | 134 | 151 | 159 | 158 | 162 |
Group2 | 338 | 324 | 282 | 197 | 139 | 124 | 111 | 105 |
Group1 =if(Source= 'X', count(PersonID))
Group2 =if(Source= 'Y', count(PersonID))
into this type of Excel chart (table not needed):
Create a combi chart with three expressions.
Give the first two expression Bar as Display option
Give the third expression Line and Symbol as Display option
On the Style tab set the Subtype setting to Stacked
On the Axes tab set the Position setting of the third expression to Right (Top) so it gets displayed on the secondary axis.
Create a combi chart with three expressions.
Give the first two expression Bar as Display option
Give the third expression Line and Symbol as Display option
On the Style tab set the Subtype setting to Stacked
On the Axes tab set the Position setting of the third expression to Right (Top) so it gets displayed on the secondary axis.
I was trying this, but was not able to get them to stack.
As a work around you have to turn it to a bar chart first - select stacked - then turn it to a combo chart...... weird
Thanks for your help.
Qlik looks way better than Excel