In-cell graphing

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):

Thank you Juice Analytics for the tip.

Comments

Leave a Reply

Your email address will not be published.

The comment language code.
*
*
By submitting this form, you agree to the processing of personal data according to our Privacy Policy.

Related Posts