3

How do I get the forecast to not show the flat line in the past and also the actual to now show the flat line in the future?

Pivot Chart

Burgi
  • 6,768
Steve Britton
  • 31

1 Answers1

4

I test on Office 365, to hide the line in Pivot Chart for blanks, please right click the Pivot Chart > Select Data > Hidden and Empty Cells > Gaps > OK > OK.

The following picture shows the display of Pivot Chart for my sample. enter image description here

Emily
  • 4,035