I was able to show data from Excel file in a organizational chart. But how do I show the data with the field name associated with it?. Showing a few numbers on a box without knowing what they are seems not useful. Alternative is to type in the field names in each of the 100+ departments, which I do not need. Any help appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Display data with field name in Org Chart
- Thread starter smin
- Start date
Hi
Is this chart being distributed electronically? How much data is there per person on the chart?
If you right click on any shape you should be able to choose 'Custom Properties' for that person. If you used the import wizard to get the data from Excel into the chart there should already be field names associated with each piece of data for that person. During this import phase you should have been able to choose which fields to include and now that you have imported you should be able to use the custom properties dialogue box to add any other pieces of data post import (better to have them stored in the original spreadsheet though and import them once).
Basically what I'm saying is that as far as I know Visio uses the custom proiperties feature to allow you to 'drill down' on any person to see more information about them. Better to have an uncluttered chart with the ability to drill down than a hugely detailed and confusing chart. And to answer your question I don't think Visio auto-generates labels on the chart.
Hope this helps.
Is this chart being distributed electronically? How much data is there per person on the chart?
If you right click on any shape you should be able to choose 'Custom Properties' for that person. If you used the import wizard to get the data from Excel into the chart there should already be field names associated with each piece of data for that person. During this import phase you should have been able to choose which fields to include and now that you have imported you should be able to use the custom properties dialogue box to add any other pieces of data post import (better to have them stored in the original spreadsheet though and import them once).
Basically what I'm saying is that as far as I know Visio uses the custom proiperties feature to allow you to 'drill down' on any person to see more information about them. Better to have an uncluttered chart with the ability to drill down than a hugely detailed and confusing chart. And to answer your question I don't think Visio auto-generates labels on the chart.
Hope this helps.
- Thread starter
- #3
Thank you for the reply.
This chart is distributed on paper. I was trying to show race/ethnicity distribution in each of the departments. So a box(department) has 5 numbers in a single column under a department name, for example, 30, 5, 2, 1, 0. This is a great feature, except that I can't indicate what the numbers mean. If I could show W 30, B 5, A 2, H 1, AI 0, it would have been much better for viewers.
A walk around I am going to do is to make a text box with field names and paste it in each of the boxes aligning it with the numbers. At least that is less chores than typing.
Thanks again for the reply.
This chart is distributed on paper. I was trying to show race/ethnicity distribution in each of the departments. So a box(department) has 5 numbers in a single column under a department name, for example, 30, 5, 2, 1, 0. This is a great feature, except that I can't indicate what the numbers mean. If I could show W 30, B 5, A 2, H 1, AI 0, it would have been much better for viewers.
A walk around I am going to do is to make a text box with field names and paste it in each of the boxes aligning it with the numbers. At least that is less chores than typing.
Thanks again for the reply.
- Status
Similar threads
- Locked
- Question
- Locked
- Question