In-cell graphing

Aug 16 2006 05:29:29 PM Posted By : Ramesh
Comments (0)

Recently read about in-cell graphing in Excel from the Juice Analytics blog. It is a very neat way to draw bar graphs inside cells immediately next to your data. It uses the REPT function to repeat the "|" character n number of times, proportionate to the data. For example:
=REPT("|";30)

Here is a sample public sheet in Zoho (click on image to go to the public sheet):

In-cell Graphs

Thank you Juice Analytics for the tip.

No one has commented yet! Be the first one to comment!

Post Comment