1 Reply Latest reply on Nov 9, 2018 5:51 PM by Shinichiro Murakami

    Stacked bar chart for YOY by month trendline?

    DAVID MACADANGDANG

      Hey all,

       

      Below is the chart I'm working with. What i'm trying to do is create a line between 2017 months and the 2018 months based on the counts as labeled. I've rummaged through the forums trying out different things such as dual axis but unable to figure it out. On Excel, I'd create a new tables of the grand total counts for each year and create a line graph for each respectively. Then I'd, impose it on a chart similar to below lining up the dots and top of the bars manually. Total hack. Any support would be great!

       

      Thanks!

       

      D

      2018-11-08_14-48-06.png