3 Ways to Add a Target Line to an Excel Pivot Chart
Get the sample file here:
http://www.exceldashboardtemplates.co...
Many Excel users use Pivot Tables and they find it very easy to create a Pivot Chart. However, Pivot Charts have some limitations as the Pivot Chart series must be part of the Pivot Table. So many users find it difficult to understand how they can add a Goal or Target line to their Pivot Chart. In this tutorial, I will show you the three ways that you can add a target or goal line to an Excel Pivot Chart.