Plot stacked bars and line in one graph

[#1]

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!!

[Josh_Good]

Hi

Here is a quick video that shows how to combine a stacked chart with a line chart.

Regards.

http://www.youtube.com/watch?v=-WIjMxAjRA4

[#3]

looks like that link shoes you how to make a fantasy football team... is there an updated link?

[Josh_Good]

I have updated the link.