add small table to a cell with sparkline in Excel
Q95. Can I add a small chart to Table data to make it visually appealing and easy to interpret?
For example, it is very difficult for Management to review the performance from raw data table as it is. Is there a way to make the data more easily interpretable?
To do it in Excel, here is the answer:
a) Select the cell to the right of last column for first employee. Under "Insert" tab, click on "Column" in "Sparklines" section.
b) "Create Sparklines" dialog box pops up. Enter / Select the range of data for first employee (AI3:AO3) and then click OK.
c) A small trend chart is introduced in cell AP3 that is far easier to interpret than reading through data in cells from AI3 to AO3.
d) Copy cell AP3 and paste from AP4 to AP12 to add the charts for the remainaing employees. Charts are added as shown below for every employee.