Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
10
Views
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.
- The First Date (this will always be the leftmost/earliest date on the axis)
- The Last Date (this will always be the rightmost/latest date on the axis)
- The Deadline (this could be any of the dates)
- 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:
- The First Date: Dark Blue
- The Last Date: Dark Blue
- The Deadline: Dark Orange
- 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
Hi Shawn,
You can't dynamically colour axis labels in charts. However, here are some ideas that you could use:
Label min and max values in charts
Mynda
Posted : 27/04/2022 10:33 pm