Clustered Stacked Bar Chart With Line. You could try to put field which have negative value in column Or another workaround is that you could create another measure for this Measure 2 if SUM Table q20 SUM Table q2 BLANK. Each data series shares the same axis labels so horizontal bars are grouped by category.
In general time series data plotted with time along the X axis are better plotted with lines than columns. However they are different. Right click the new series choose Chart Type and select the line without markers option.
Insert a stacked chart.
Excel offers a stacked line chart option. The markers show the discrete data values and the connecting lines help to show the trends. Given a list of dataframes with identical columns and index create a clustered stacked bar plot. Clustered bars allow the direct comparison of multiple series in a given category but its more difficult for the human eye to compare the same data series across categories.
