Jump to content

Hide X and Y axis labels


Recommended Posts

Hi all

I use a bar chart to visually show the amount of fuel available in tanks. The users create entries as fuel is used which in turn adjusts the data.

I want to hide the labels FM automatically adds to charts as my solution already displays this data in another form. The chart is merely a visual reference and I don't needed the added labels. Is there a way to do this?

Link to post
Share on other sites

You cannot remove the labels, but you can format them to the same color as the background.

If all you need is bars, consider using another tool - e.g. conditionally formatted repeating fields or a web viewer.

 

Link to post
Share on other sites

Hi comment

Thanks for mentioning that - I do remember seeing repeating fields used as a bar graph. Is there a demo file or thread you can point me to? I think that'll achieve exactly what I need.

Cheers

Link to post
Share on other sites
  • 3 months later...

Hi @comment

I'm trying to use your repeating field bar graph method to display time elapsed between dates. The calculation calls for a set date in the future based on today's date. If the date is passed the current date I need the graph to turn red. I'm getting some weird results just plugging in the date fields to the existing conditional formatting calculation. Here is what I have 

Let ( [
maxValue = Aircraft::Annual_Due ;
segments = 100 

] ;
Get(CurrentDate) - Aircraft::Annual_Due / maxValue  ≥  Get ( CalculationRepetitionNumber ) / segments  
)

Probably missing something very obvious but help is appreciated.

Link to post
Share on other sites
3 hours ago, madman411 said:

Hi @comment

I'm trying to use your repeating field bar graph method to display time elapsed between dates. The calculation calls for a set date in the future based on today's date. If the date is passed the current date I need the graph to turn red. I'm getting some weird results just plugging in the date fields to the existing conditional formatting calculation. Here is what I have 



Let ( [
maxValue = Aircraft::Annual_Due ;
segments = 100 

] ;
Get(CurrentDate) - Aircraft::Annual_Due / maxValue  ≥  Get ( CalculationRepetitionNumber ) / segments  
)

Probably missing something very obvious but help is appreciated.

Well I figured factoring in the most recent Annual (Aircraft::MostRecent_Annual) would help but I'm not sure how to set a minValue.

 

Edit:

Ok, I've figured out the way to achieve the numbers I need. Dates are in US format for the example below.

Most Recent Annual: 12/12/2020
Next Annual Due: 12/12/2021
Current Date: 5/2/2021

barGraph is a repeating number field with 100 repetitions.

Let ( [
maxValue = Aircraft::Annual_Due - Aircraft::mostrecent_Annual ;
segments = 100 

] ;
Aircraft::Annual_Due + Get(CurrentDate) - Aircraft::Annual_Due - Aircraft::mostrecent_Annual / maxValue ≥  Get ( CalculationRepetitionNumber ) / segments
)

In the above code the first part gives me a figure of 141:

Aircraft::Annual_Due + Get(CurrentDate) - Aircraft::Annual_Due - Aircraft::mostrecent_Annual

The second half gives me a maxValue of 365 (one year)

maxValue = Aircraft::Annual_Due - Aircraft::mostrecent_Annual ;

Therefore, the conditional formatting graph calculation together should give me a figure of around ~38.6% on the bar graph itself, however regardless of what I try it keeps giving me a full graph (100%). 

Edited by madman411
Link to post
Share on other sites

If I understand correctly what you're trying to do (which is by no means certain), you want to have two conditions in your conditional formatting.

The 1st condition would be: 

Let ( [
total = Aircraft::Annual_Due - Aircraft::mostrecent_Annual ;
elapsed = Get ( CurrentDate ) - Aircraft::mostrecent_Annual ;
segments = 100 
] ;
elapsed / total ≥ Get ( CalculationRepetitionNumber ) / segments  
)

and this would color the elapsed portion by some color.

The 2nd condition would be: 

Get ( CurrentDate ) > Aircraft::Annual_Due

and this would color all segments red when the due date has passed.

--
Of course, if the interval is always one year, then one of those fields is redundant.

 

Link to post
Share on other sites

Thanks Comment. I didn't realize the conditions needed to be calculated in the Let function first. Correctly organizing it all worked a treat.

For what it's worth, the interval SHOULD be a year, but in some instances it is not. 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.