Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys
I need a graph that contains the evolution of my KPI for the past 24 months
here's my graph :
my expression : month(DATE_CALCUL) and date calcul has this format : DD/MM/YYYY
read this post
Last 24 months for what? While selection you need <24 Months? Can you describe more
Dear Weim
I have an idea
your chart can calculate all months value but shows last 24 months (actually it has not good performance but solve your problem)
for this can set "when number of item exceeds" =24 in presentation tab and this macro to save scroll of chart at right the macro as below:
set chart = ActiveDocument.GetSheetObject("CH01")
set chartProperties = chart.GetProperties
chartProperties.ChartProperties.XScrollInitRight = true
chart.SetProperties chartProperties
I prepare sample for u but I show the last 4 months value
hope it is helpful for u
Thank you Samane, will try and let you know