Forum Discussion
Dynamic series in chart
I am a novice to EXCEL and trying to prepare a monthly progress chart as per the attached WB. It is noticed that as per actuals in the part of the year if I have blanks for subsequent months my serie...
Click anywhere on the chart.
Activate the 'Chart Design' tab of the ribbon and click 'Select Data'.
Click the 'Hidden and Empty Cells button'.
Select Gaps as option for 'Show empty cells as', then OK your way out.