I have to build chart for campaigning data. I have chart to plot sales by date wise. In same chart, I would like to add reference line for campaign date and label should be campaign description. This reference lines should be dynamic, that for future campaign dates should show up as reference dates automatically.
Can anyone help me here ?
did you try using dual axis chart for this?
1. Drag Campaign date to chart, make it dual axis chart.
2. Right click on secondary axis and add reference line for Campaign date
3. make transparency to 0 for secondary graph to hide it.
4. disable show header to hide axis
hope that helps.
Please share sample workbook to replicate steps.