Create a sparkline group in Excel

A group of sparklines can be created in Excel, as well as single sparklines. The main benefit is to customize all the charts together. The video above starts with a table of data, and with the first sparkline already created, spanning two columns (using the ‘Merge & Center’ command). To add additional sparklines, drag the right-hand corner of the sparkline down to fill the cells below. Each sparkline picks up the data in its row. When one of the sparkline charts is selected, a (vertical) boundary box highlights the grouped sparklines. Choose axis, marker and color options which will be applied to all the charts. See more about sparklines on our web page here excelquick.com/excel-charts/excel-sparklines/

• #education
• #excel_sparklines