conditional text on axis

[lockematthewp]

I currently have a bar chart showing actual hours vs forecasted hours. these are split by project numbers. I want to show the project descriptions on the x axis. I am able to do so but it shows for both the actual and the forecast bar for each project. how can I only show the description on the larger of the two bars? I cant figure out how to compare the expressions. I would really appreciate any help.

[Anil_Babu_Samineni]

Try to share sample application to help

[lockematthewp]

This is for work so I am unable to share the actual file. but I made a similar one as an example. I would only like to show the project description on the larger of the two bars. as of now I show it only on the forecast bar, but some projects have no forecast value so no description is shown.

[Brett_Bleess]

Matthew, The only way I see to potentially do it is to have the Desc field be null for the Forecast, but I am not sure how to do the data model to accomplish that and still have things properly linked.  The problem is with everything in single table, the Desc applies to all rows etc.  If you could split the Actual and Forecast into two separate tables where in the Forecast table the Desc is null, I think that would get you what you want here, and as far as I can see, that is the only way to go at things, but I am not a development guru, so hopefully someone else may now see this and think of another way to go at it, but I wanted to toss this out just in case you may be able to make it work.

Regards,
Brett

[lockematthewp · Accepted solution]

I managed to solve this by just concatenating the description to the Project No. with a space in between.

=[Proj No(B)] & chr(10) & [Project Des(B)]