Plotting a chart with exclusion of prospective data

virtuosok

Board Regular
Joined
Sep 2, 2020
Messages
72
Office Version
  1. 2016
Platform
  1. Windows
Hi,
I have a set of incremental figures which are registered each month, as follows:
Capture.PNG

Based on these, I build a simple chart for planned and for actual (cumulative) figures, as follows:
Capture2.PNG

How can I exclude prospective cumulative entries from the chart? (currently this goes 2-2-2-2-2 and it doesn't bring any value, only makes the chart busier...) I can select the range needed, manually - each month, but I have a whole series of such charts so this is not very practical. Is it possible to "hide" prospective entries either in source file, or in the chart? E.g. by comparing the month in column A with current month and if it's in the future, hiding respective entries in column D in such a manner that they don't show up on the chart?
 
Last edited:

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,118,750
Messages
5,574,016
Members
412,562
Latest member
woodportaj
Top