google charts stack bars from different lines

#Google charts stack bars from different lines series#

In order to achieve an Excel Chart with both stacked and unstacked columns that are side-by-side, you will have to move some of the data to the secondary axis and also manipulate the chart data by adding some filler series.Ĥ) Move Stacked Column Data to Secondary axisĥ) Change Chart Type of Secondary Axis DataĨ) Delete Secondary Vertical axis Step-by-Step 1) Add Filler Series There is not an option for a stacked and clustered column chart on the same axis.

Any column type data (vs line data as you can combine line and column charts) will be plotted as part of the stack on the same axis. This means that you can only choose a stacked column chart OR clustered column chart for each axis. In Microsoft Excel, data plotted as a Stacked Column or Stacked Bar Chart Type on the same axis will be stacked into a single column. This is what the final chart would look like: Final Stacked and Non Stacked Clustered Column Chart Excel Chart Standards Is there any way to have the left bar be a solid “quota number” and to the right of it have a stacked bar made up of the two types of sales. “Is there any way to compare a stacked column to a non-stacked column? Example, at work, I have to graph a sales quota bar next to actual sales which are made up of two types. For instance, I received the following Excel chart question but this is not something that you can do normally in Excel without knowing this trick/technique. Stacked and Unstacked Column Chart in ExcelĮxcel is awesome because, even when a certain chart type is not a standard option, there may be a way that you can create the type of chart that you really wanted to make.

Google charts stack bars from different lines