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?

excel add small table to a cell with sparkline

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.

excel excel add small table to a cell with sparkline

b) "Create Sparklines" dialog box pops up. Enter / Select the range of data for first employee (AI3:AO3) and then click OK.

excel excel excel add small table to a cell with sparkline

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.

excel excel excel excel add small table to a cell with sparkline

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.

excel excel excel excel excel add small table to a cell with sparkline

 

You can find similar Excel Questions and Answer hereunder

1) How can I add a Prefix to a set of numbers in a range?

2) I want to add a trend indicator symbol next to my sales data - how can I do that?

3) How can I enter a text in a cell with subscript and superscript?

4) How do I add a shape using VBA?

5) How can I add a Footer to my printout with automatic page numbering?

6) How can I add a WorkSheet and name it as required using VBA?

7) How do I enter a formula in a cell using VBA (using Absolute Reference)?

8) How can I find the last used cell in a Column in VBA?

9) How can I add interval to dates?

10) How can I set the fill color, font color and set number format of cell to date?

11) I have a large list of clients whose current Age I need to maintain in my database as it influences costs - how can I have Excel display the current age at all times?

12) How do I enter a formula in a cell using VBA (using Relative Reference)?

13) How can I get input from user through a prompt and assign user's input to a cell?

14) I track a stock on a daily basis and enter the Open, High, Low and Close values for every trading day. In Excel, how can I automatically get High and Low values for the last 10 trading days?

15) How can I identify all cells with Data Validation in my WorkSheet?