How to show only values for December on monthly line chart over multiple years

[#1]

Customer wants to build line chart by month (YearMo) and only show the values on chart where the month is 'December'. All other months will just show the plot but no amount. Please advise.

Thanks,

Kevin

[#2]

Hi KKelly

could not understand what values are you talking? The values over the line or the dots that would be connected to show the dots?

Cheers

Adriano

[#3]

Sorry, the values associated with the dots (plot points). So if my X axis is YearMo and I'm plotting Revenue, I would like to see the plotted value visible on the chart (e.g. $1,234,456) when the month is equal to 'December'.

[#4]

Hi

create another series and use the same formula but with an if

if( YEARMO = 'December', VALUE) // value is your formula

Make this new series INVISIBLE and VALUES OVER DATA (expression tab). That will make the trick. (I have made an example but could not upload).

Cheers,

Adriano

[#5]

You Can restrict Date for december using if Condition Like if MONTH='DEC',Value

and for other plot u can make them invisble by expression tab/////

Try this best of luck

Dushyant