The initial data table is something like this: For this example, lets use fictitious sales data of various beverages over the last 12 months. Once you have downloaded the font, the rest is simple process. You should download bargraph font if you want to use incell bar graphing technique mentioned here. When you use bargraph font, 0 through 9 will show bars of increasing heights, as shown below. I quickly created a bar graph font using their wonderful editor. Thankfully this is when I noticed Font Struct, an online font creator / editor. My first challenge was that there was no font readily available for bar graphs. What more, these would probably look gorgeous when printed out. An in-cell bar would probably be more useful and cuter than an in-cell pie as it can instantly provide trending details. Ever since writing the create in-cell pie charts in excel, I have been itching to find a simple enough method to do incell bar graphs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |