MileStone / TimeLine

Will create a Milestone/Timeline chart based on a selection that is 3 columns wide (Milestone, Milestone Description, Point Height), and at least 2 rows high (must include headers). All series in the chart will be dynamic named ranges, so you can add rows and the chart will pick them up automatically. However, there can be no blank rows in these 3 data columns!

NOTE: VBA Charting between Excel versions is extremely glitchy. Your output may not looks exactly as depicted, but it should get you nearly there. If you have Excel version 2013+ check out the DataLabel Width Adj on the Nutilities Menu Charts tab to help resize the datalabels for these charts.

Leave a Reply

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