Formatting in-cell graphs in Excel

Formatting in-cell graphs in Excel 2007
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.

Watch the video:

You can also create a Gantt chart in Excel by using the above ‘rept’ as shown in the image below.

In cell graph for Gantt Chart

Gantt Chart Using In Cell Graphing

Further reading:
In Cell Graphing

Leave a Reply

Your email address will not be published. Required fields are marked *