9 Replies Latest reply on Oct 26, 2016 10:26 PM by Rahul Verma

# In a Time Chart, How can I Highlight a Mark every time a new max is reached?

Hi Everyone,

I am learning and will appreciate all the help I can get. I am trying to highlight the marks on a time chart every time a new max is attained. I have attached a workbook.

Thanks.

Udy.

• ###### 1. Re: In a Time Chart, How can I Highlight a Mark every time a new max is reached?

Hi Udy

I have attached screenshot as well as Workbook. I am sure this will help you.

Window_Max calculation solves the purpose. It's Dynamic and will highlight the max value always!

Let me know if it helps

Thanks & Regards

Rahul

1 of 1 people found this helpful
• ###### 2. Re: In a Time Chart, How can I Highlight a Mark every time a new max is reached?

Thanks Rahul! I am very grateful!

• ###### 3. Re: In a Time Chart, How can I Highlight a Mark every time a new max is reached?

Hi all,

I still need help with trying to solve this problem. The solution above highlights the Max sale for all 4 years. What I am required to show is a new highlight for EACH month there's a new Max from 2010 until 2013.

Thanks guys.

Udy.

• ###### 4. Re: In a Time Chart, How can I Highlight a Mark every time a new max is reached?

Hey Udy!

Good Morning!

As far as i got you ques, you now want to see the particular months for each year and in which year that month is at highest sales! Right?
Example, January is performing highest in which year!

This is easily possible. Workbook is attached you just have to right click on Window_Max and select "Compute Using" as Pane across.

Please let me know for further help

Let me know if it solves the issue.

Thanks

Rahul

1 of 1 people found this helpful
• ###### 5. Re: In a Time Chart, How can I Highlight a Mark every time a new max is reached?

Hey Rahul,

"Compute Using Pane Across" will highlight only one max value for each year. What I want to achieve is to highlight every max value from January 2010.

So for January 2010, that will be highlighted, because it is the only value so it is max, Feb will be compared to Jan, if higher, then highlight, if not, then compare March to January, else compare March to February, and we do this across to 2013.

I hope this explanation helps. Thanks a lot.

Udy.

• ###### 6. Re: In a Time Chart, How can I Highlight a Mark every time a new max is reached?

Hi Udy

I am attaching a screenshot. Please let me know if this is what you want because i am not clear enough with the question! Can you explain a bit more. Here I have highlighted max for each month compared in all years and the overall max in all the years! Note: Column shelf contains month first and then year.

Rahul

• ###### 7. Re: In a Time Chart, How can I Highlight a Mark every time a new max is reached?

Sorry Rahul, Let me try to explain.

Year should come before month on the column shelf, but that's not all.

Each month's sales value should be compared to that of the previous month and highlighted if the current month is higher.

However, if the current value is not higher than that of the previous month, then it should be compared with the last known max value and highlighted or else move on and repeat the comparison.

I hope this helps.

Thanks,

Udy.

• ###### 8. Re: In a Time Chart, How can I Highlight a Mark every time a new max is reached?

Hey Rahul!

I found the solution to the problem.

Use this Calculation: RUNNING_MAX(SUM([Sales])) = SUM([Sales]).

Drag this field on color and and set  to compute using pane across.

Thanks for trying.

Udy.

• ###### 9. Re: In a Time Chart, How can I Highlight a Mark every time a new max is reached?

Hey Udy