2

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,493
  • 14
  • 39
  • 52
Steve Britton
  • 21
  • 2

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
  • 3,339
  • 1
  • 4
  • 6