google charts stack bars from different lines

Google charts stack bars from different lines series#

While I’m “stuck” with the technical problem noted above, perhaps I’m headed down the wrong road anyhow.

Google charts stack bars from different lines series#

I don’t know if this matters, but I associated the Budget series with the secondary axis before attempting to insert those final blank rows. When I try to add that blank row at the beginning and end of the data block to provide a little separation between the first column and the y axis and the last column and the right edge of the graph, (my equivalents of) the Q1 and Q2 Budget series “uncluster” and get stacked back on top of the Actual series. Sure, you can reduce the gap width, add blank rows in the data (but make sure the cells highlighted yellow contain a space character to preserve spacing of axis labels).īut this does not solve the cluttered axis issues in point 3. You don’t get the visual clustering as in the tutorial above. There is an extra level of labels which may not be needed and may in fact add to the clutter.Ĥ. There are excess lines among the axis labels, which may make the chart seem cluttered.ī. This is fine in some cases, and I’ve written about it in the past (see for example Chart with a Dual Category Axis). This groups the stacked columns using lines among the axis labels. Merging the cells makes no difference Excel centers the outer labels across the inner labels regardless.ģ. The top chart below is clustered, the bottom one is stacked.Ģ.

I think you meant to choose a stacked chart. I’ve taken a screen shot of the data to clarify it for other readers.