I have a stacked bar chart which shows values by customer by week. I want to add a line graph to compare the total value by week for the previous year. If I do a combo chart it won't let me choose stacked as an option for the bar chart, and if I have customer as a dimension the line chart is wrong. Is there a way around this?
I know this won't sound good, but what you can do is a workaround, just add a copy of the chart you're using and change it to combo chart, add line graph and make the bars invisible and change the transparency of the background to 100%.
This may degrade your performance so use it wisely.