I’ve also used a lighter shade of orange for the columns, to make the markers stand out better. We finish by right clicking on the “Actual” data, choosing Change Series Chart Type from the pop-up menu, and selecting the new chart type we want. We start by selecting the data and inserting a column chart. The chart will use the first column for horizontal axis category labels, the second column for actual values plotted using lines with markers, and the third column using columns (vertical bars).
I’ll illustrate a simple combination chart with this simple data.
I’m here to help with Bar-Line, or rather, Bar-XY combination charts in Excel. But if one series type is horizontal bars, then combining this with another type can be tricky. Building a combination chart in Excel is usually pretty easy. Combination charts combine data using more than one chart type, for example columns and a line.
