This method will guide you to manually add a data label from a cell of different column at a time in an Excel chart. But that doesn’t mean you can’t present a lot of data with it. In addition, many users – who try to combine them manually – have been confused as to how to consolidate the source data, the series and the graph axes for both charts at the same time. There are spaces for series name and Y values. Insert a chart and select the line chart and select the entire table of data and Excel will perform its magic. No matter your issue, I’m certain someone there can inform you of the best way to reach your solution. An Excel Combo chart lets you display different series and styles on the same chart. The vertical axis (Y-axis) … Your example was a godsend! Grouping the data in this way is required for the next stage of combining the charts. Does anyone know if there is a way to easily rearrange data into the required format to make a stacked chart? Currently, the first column in each cluster has the same colors and the second colum per cluster other colors. The Line Chart. To create a column chart, execute the following steps. We’ll start by naming the next cell after cell Q4 (cell F4 in the screenshot) as “Inv. Microsoft Quick Tip: Visualize Your Data in an Excel Bubble Chart, Export Excel Charts to Word and PowerPoint Using Copy/Paste, Interactive Excel Charts: Create a Chart Selector, When to Use Microsoft® Excel® for Text Products, Preparing Final Products using Microsoft® Excel®, Select the series you want to edit, then click. Pro tip: Because we activated the Chart Area before the TextBox was inserted, it’s linked to this Chart object, so we don’t need to group them. Once the Quarters and Revenue have been switched, we may notice that there are six series now related to every single row in the Revenue column (i.e. Below the details: Sub ChartValue2() Dim rg As Range Dim i As Integer i = ... my code is selecting the whole range from column 1 to 3, but what I want is to select column 1 & 3 separately. Enter an Item Number from the catalog to view details. There are several different methods to tackle this, so let’s discuss the relatively easy (and less confusing) method: where there are several secondary chart axes using the same dynamic Min and Max values. Clustered Column Chart in Excel Example #1. Assume your data is in the range A1:F18, with W in columns A:C and D in columns D:F. Select the range A1:A18 together with range D1:D18 (hold down Ctrl to make the second selection). I followed the same steps but one of the bars get hidden behind.