Hi,
I have a set of incremental figures which are registered each month, as follows:
Based on these, I build a simple chart for planned and for actual (cumulative) figures, as follows:
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?
I have a set of incremental figures which are registered each month, as follows:
Based on these, I build a simple chart for planned and for actual (cumulative) figures, as follows:
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: