The CONCATENATE function concatenates (joins) join up to 30 values together and returns the result as text In Excel 19 and later, the CONCAT function and TEXTJOIN function are better, more flexible alternatives The CONCATENATE function accepts multiple arguments called text1, text2, text3, etc up to 30 totalValues may be supplied as cell references, and hardcoded textIf I create a column chart with the default options, we get a chart with three data series, one for each year In this chart, data series come from columns, and each column contains 4 values, one for each product Notice that Excel has used the column headers to name each data series, and that these names correspond to items you see listed inExcel then adds these as new columns representing the data series Since you want the average to show up as a line instead of columns, right click on the data series and select Change Series Chart Type The popup window will show you the chart type for each data series Change the Chart Type for the Average series to a Line chart
3
