How can I create Sparkline chart in Excel 2007?

visualization
excel

#1

Hi,

I am using Excel 2007 and want to create a sparkline (cell) chart in excel. I know it can be done easily in excel 2013 (added feature). Is there any way to create sparkline chart using existing function(s) or inbuilt feature. Please help!

Regards,
Pravin


#2

Hi Pravin,

You can perform similar kind of visualization using function rept(). You can see in below image that %Achv variable is represented visually using rept() function.

Thx,
Mukesh