Forum

Notifications
Clear all

Dynamically format specific axis value in a chart

2 Posts
2 Users
0 Reactions
67 Views
(@swallack202)
Posts: 77
Estimable Member
Topic starter
 

Hello -

I have a chart that shows dates along the horizontal axis. There are always 28 dates on the chart, and the dates change based on table values. There are four "special dates" that I'd like to draw attention to.

  1. The First Date (this will always be the leftmost/earliest date on the axis)
  2. The Last Date (this will always be the rightmost/latest date on the axis)
  3. The Deadline (this could be any of the dates)
  4. The Forecasted Completion Date (this could be any of the dates)

I have figured out how to dynamically add text to these 4 axis values (e.g., instead of "04/26/2022" the date would appear as "** 04/26/2022 **"). However, what I'd like to do is color code each of these four axis values differently. For example:
 

  1. The First Date: Dark Blue
  2. The Last Date: Dark Blue
  3. The Deadline: Dark Orange
  4. The Forecasted: Green if earlier than deadline (which I can figure out) or Red if later than deadline (which I can figure out)

Many thanks!

 
Posted : 27/04/2022 11:18 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Shawn,

You can't dynamically colour axis labels in charts. However, here are some ideas that you could use:

Label events in charts

Label min and max values in charts

Mynda

 
Posted : 27/04/2022 10:33 pm
Share: