Click OK and close With our name set up, we are ready to create the chart Build the chart We get our starter chart going by selecting any cell in the FV column and then inserting the desired chart (Insert > Clustered Column Chart) ExcelExcel 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 Concatenate Use On Chart Title I'm using concatenate to name a chart title My problem is that when I concatenate two dates I lose the date format I'm after a title which looks like 06 December 07 13 December 07 I'm actually getting The cells have been formatted in date format but lose this when concatenated
How To Use The Concatenate Function In Excel Video Lesson Transcript Study Com