learn microsoft excel

Formatting in-cell graphs in Excel

Home Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
About Us Free Ebook Offline Training Our Youtube Videos

Once the graphs have been created using the REPT function, you can reduce the size of the graphs, put a value at the end of the graph with a pre-defined space(s). Then you can apply conditional formatting rules on your Excel data to color the in-cell graphs to highlight data based on defined conditions. This makes it easier for the user to view data.

You can also create an Gantt chart in Excel by using the above 'rept' as shown in the image below.

Further reading:
In-cell graphing

creating gantt charts

Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
About Us Free Ebook Offline Training Blog Our Youtube Videos