woensdag 30 april 2014

Excel: Chart With a Target Line Based on Just one Value Which Expands Automatically

Can you base a target line in a chart on just one value? Yes, you can! And will it expand dynamically? Yes, it will!

Here are the data and no, there is nothing hidden:

Month Value Target
jan 60 60
feb 65
mrt 70
apr 75
mei 80
jun 85
jul 90
aug 95
sep 100
okt 105
nov 110
dec 115

You can download the file ExcelGrafiekHerhaling.xlsx through

Een reactie plaatsen