fbpx
Search
Close this search box.

All articles with 'Charts and Graphs' Tag

Creating in-cell bar charts / histograms in excel

Published on May 13, 2008 in Charts and Graphs, hacks, ideas, Learn Excel, technology

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. An in-cell bar would probably be more useful and cuter than an in-cell pie as it can instantly provide trending details. What more, these would probably look gorgeous when printed […]

Continue »

Create in-cell pie charts in Excel

Published on May 7, 2008 in Charts and Graphs, hacks, ideas, Learn Excel, technology

Here is a ridiculously easy trick to do nice incell pie charts in excel, what more, they will make you look like a charting wizard. Download free pie chart font from here (direct download link). The font has 21 pie chart codes starting with empty circle (character ‘a’) and ending with full circle (character ‘u’) […]

Continue »

Generate organization charts in excel – howto?

Published on Apr 15, 2008 in Charts and Graphs, hacks, Learn Excel, technology

Here is a ridiculously simple workaround for those of you trying to generate an organization chart in excel: Use google org. chart widget instead 🙂 [If you are reading this in a feedreader this post may not display properly, visit the post page instead.] Open a new google docs spreadsheet (or work on the example […]

Continue »

How to get more colors in excel chart – simple trick

Published on Apr 9, 2008 in Charts and Graphs, hacks, ideas, Learn Excel, technology

Here is a simple to trick to beat the 56 color limitation in excel when you are designing a chart: use picture files (jpg, gif, png etc.) to fill the chart area. You will no longer have to worry about limiting your project report / website / annual report etc. colors to the 56 that […]

Continue »