4 Replies Latest reply on Sep 17, 2013 9:36 PM by Louis Keating

# Find Axis Maximum in One Worksheet, Apply to Another.

Hey guys!

Sorry in advance for the confusing question...

I've got two charts which need to have the same axis maximum.  Since axis maximums aren't dynamic, I'm using a calculated field and a reference line.

How can I use this calculated field and apply it to the reference line on two sheets?

The formula for my Max x Axis is:

(SUM([Likes])/COUNT([Likes]))*1.15

Which is doing the same calculation as my chart, then increasing by 15%.

When I use the same on my second chart, the Sum and Counts are different, so how can I pass the result of one calculated field into the second?

Thanks,

Lucas

• ###### 1. Re: Find Axis Maximum in One Worksheet, Apply to Another.

You can probably use a table calculation to get the max value, add this to the level of detail for the second sheet, then set a reference line using this. See the attached - I have not taken the next step of formating the ref line to be not visible.

1 of 1 people found this helpful
• ###### 2. Re: Find Axis Maximum in One Worksheet, Apply to Another.

Hey Alex,

Nice Avatar by the way ;-)

I tried something similar to this. The problem is that the two charts have different date ranges. Chart 1 is THIS MONTH and Chart 2 is an average of the 5 months prior to this month. A table calc works when the date filter is off/the same but not when they are different.

Cheers,

Lucas

• ###### 3. Re: Find Axis Maximum in One Worksheet, Apply to Another.

Do you have a filter on the second that's causing the reduced range?? If so, then there is one possibility

• ###### 4. Re: Find Axis Maximum in One Worksheet, Apply to Another.

I've got a date filter on both charts.

Chart 1: Filtered to show the last 6 months of data (not including the most recent month)

Code:

[Date] END

Chart 2:  Filtered to show the most recent months data

Code:

IF[Date]< DATETRUNC("month",Today() ) AND