IvanWeiss
5 years agoQrew Captain
Override Stacked Bar Chart Legend
Good morning,
I had a bar chart showing the expecting invoicing over the next 11 months. I wanted to be able to see how much I have billed towards the goal so I created a field on my invoices table which is a checkbox and it is a formula checkbox. If it sees an invoice # it marks the field true meaning that it was invoiced to the client. GREAT, works fine.
I use this on my stacked bar chart and it works great.
Except the data label of yes/no will not make sense to an end user. Is there a way to override that? If not I think I need to switch the checkbox formula field to a text formula field and use that to create better labels. Just wasnt sure if I can override it in the report settings somewhere.
Thanks!
------------------------------
Ivan Weiss
------------------------------
I had a bar chart showing the expecting invoicing over the next 11 months. I wanted to be able to see how much I have billed towards the goal so I created a field on my invoices table which is a checkbox and it is a formula checkbox. If it sees an invoice # it marks the field true meaning that it was invoiced to the client. GREAT, works fine.
I use this on my stacked bar chart and it works great.
Except the data label of yes/no will not make sense to an end user. Is there a way to override that? If not I think I need to switch the checkbox formula field to a text formula field and use that to create better labels. Just wasnt sure if I can override it in the report settings somewhere.
Thanks!
------------------------------
Ivan Weiss
------------------------------