Mix summary and detail activities on a graphical report without overlapping jumbled letters next to the summary bar and keep tex

J
John Reeves 👤 Member for 13 years 1 month

Mix summary and detail bar description names - without a jumbled typo line next to the summary bars.  I guess I could create a custom column and have it blank for WBS items that I will roll-up but I assume there should be a way without the extra step that someone have figured out...

M
Mike Testro 👤 Member for 20 years 6 months

Hi John

Work on a spreadsheet with the text in different columns and you can concatenate the cells into one text string.

such as:

B3&C3&D3

If you need a text diveder such a a space or - then put this into cell B2 and the concatenation would run:

B3&$B$2&C3&$B$2&D3

This formula can then be coppied down the spreadsheet.

I use concatenation to create text strings for delay analysis reports.

Best regards

Mike Testro

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts