Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I need to plot 2 values on a graph.
First, I need to plot a stacked graph which has Y='spend', X='months' and the stacked categories='channel'. So the graph shows the total spend per month by media channel in a stacked bar chart.
Second, I need to add a line into the graph to show the 'sales' by 'month'. Spend will be on 1st axis (£1-10mil) and Sales will be on 2nd axis (£10-100mil).
Is there a way to do this? At the moment, I can only get grouped bars with a line in one graph, how do I get stacks and line in one graph? Thanks!!
You can get line and bar chart at the same time by combo chart option but as per my knowledge you cannot do stack in combo charts.
See the attachement.
Regards,
Shumail Hussain
Use Combo Box chart type.
X='months' is a dimension.
Y='spend' - first expression as Bar.
'sales' by 'month' - second expression as line.
thank you but I still cannot get the spend to display as a stacked bar marking the spend per 'channel', any ideas?
thanks!
Add the 'channel' as second dimension.
Add 'channel' as second dimension.
Antheayeung, see the attachement i have posted, i hope it will surve ur purpose
I'm sorry, I'm using the personal edition so I can't open it.
Hi
You can use a combo chart type. It will stack the expressions that are bars and display the lines normally. Make sure that two or more expressions have only Bar checked under the Display Options in the Expressions tab and one or more expressions have only Line checked. Select Stacked on the Style tabbed.
I use this quite often on QV9
Regards
Jonathan
I think the issue here is that you cannot stack two dimensions and have a second expression (line in this case). Seems like a serious limitation - I have tried this in the past... and failed