In EXCEL - I want to have line chart showing Planned vs Actual over time (weekly). I have 5 data points for Planned. I want to show Actual results only when there are non-zero values.

In the Pivot Table, click the arrow to the right of the Report Filter dropdown, check ‘Select multiple items’, uncheck the 0 value and click OK. Now the rows containing zero values in the Pivot Table have been hidden.

Details: the Actual data series is a count of data entered. For example, at end of week, someone enters actual results in series of columns.

The 'count' of these entries makes up the Actual total to be plotted. Thus, after 3rd week, the person has entered data for week 1, 2, 3, and there is total for Actual for those weeks.

Total for week 4, 5 is zero cause there is no data. Unfortunately, when plotting the Actual total - the chart seems to think that the formula should be translated into a value on the chart - whether there is data or not. Thus, the line on chart for Actual shows data for week 1, 2, 3, then line goes to zero for week 4, 5. I want the line to stop after week 3. How do I get the chart to not show week 4, 5 until the value is non-zero?

Download Free Skout for PC using our tutorial at BrowserCam. Learn how to download and also Install Skout on PC (Windows) which is certainly developed and designed by Skout Inc. Containing great features. Lets understand the specifications so that you can download Skout PC on MAC or windows computer with not much trouble. Skout download for mac.