Microsoft Excel Tips and TricksA target line or average line is a powerful visual that allows you to compare how actual data compares to their goal or budget. Visualizing such a target line in a dynamic way in a Microsoft Excel chart is not that simple. Specially adding a target line to a bar chart. In this video I’ll show you a super easy way to create such dynamic target lines for both a column chart and a bar chart.
Credit Leila Gharani