Can I change the headings of the Excel table? I want to use this style of chart but applied to different data.
@TaniaKahtun-h7g29 күн бұрын
microprokey
@trevorlonewolf6406Ай бұрын
What an idiot Going through a redesign of the ribbon etc and a long way around to show something very simple Dont be a twat Do its simply and immediate
@francescomarzio56652 ай бұрын
Hello, it's a very interesting video ! Thank you very much ! I'd like to automate the refresh of the table. do you think is it possible ? I have tried with Power Automate but i experienced some problems to identify the right window (registered actions). I'm a novice with this softwares , i cant find a solution. thank you very much for your attention
@rahafal37872 ай бұрын
قصرت رجلك 🎉
@weihu20642 ай бұрын
it doesn't work on 2021 pro
@carlosm55913 ай бұрын
Is it possible to insert the data of the field inside the rectangle. Thanks!!
@visu561413 ай бұрын
Sir how to get yellow point for user defined box will you please explain thank you sir
@robertnickel88494 ай бұрын
Hi David! At about the 3:10 mark here, we see Visio auto-rearrange your arrow in a much less desireable way. You were able to fix it easily here, because the shapes you were using have multiple attachment points. However, I am a database administrator and mainly use Visio for database diagrams, and a constant frustration is the way that Visio will choose a side of a table object to attach the relationship line, and I have never been able to figure out how to manually change that. Do you have any insights on this question?
@rebeccaross19665 ай бұрын
This is great! I would love a tutorial for this!!! 🙋♀
@robmahony5 ай бұрын
thanks boss.
@reyzox.98606 ай бұрын
Just how to make the text grow synchronously with other forms ? thx
@reyzox.98606 ай бұрын
Just how to make the text grow synchronously with other forms ? thx
@fpchd6 ай бұрын
Thanks for you replies! I will implement your suggestions!
@fpchd6 ай бұрын
And I have a second challenge: I would like to have four different org-charts in one visio file. all four charts are based on 4 different tables in excel ( one chart for each department). any idea how to achieve this?
@bsmartbclearbvisual6 ай бұрын
You can create multiple queries using PowerQuery / Data | Get & Transfor Data, then use these for the source of different org charts on separate worksheets
@fpchd6 ай бұрын
Hi David, nice video-series of visio data vizualiser. Do you know if its possible to change the default colors of different role types in an visio data visualizer org-chart? i was able to change the underlying list of roles based on our internal role structure, but now all shapes have the same blue colorcode. I wasnt able to find editing of colorcodes of the shapes based on role types.
@bsmartbclearbvisual6 ай бұрын
The default colors are just using the page theme. If you want to color by department or anything else, then open in Visio Desktop and select the data row in the Data Graphics panel (with no shapes selected) then tick to apply Data Graphics, and chnage it to Color By Value, then Configure
@fpchd6 ай бұрын
@@bsmartbclearbvisual this worked very good! thanks again
@JanJensen-ec7xq6 ай бұрын
Hi David, Can the above video be used to update text boxes over 25 pages? I have run into a problem, you have previously described that not all pages get the text updated, sometimes they do and sometimes they don't. I need 5 master boxes that automatically update the text on 25 pages, is it possible?
@pcbecalette6 ай бұрын
This was incredible! Thank you so much for sharing your knowledge! Best regards.
@brianching43586 ай бұрын
Possibly the least helpful video on YT. No context, no showing how to get to where you're at, no explanation that Layer Manager isn't even a built in visio function.
@bsmartbclearbvisual6 ай бұрын
Well Brian, that is because it is one of a series of videos that were created as content for my blog and website, see bvisual.net/products/layermanager/ . I hadn't realised that they would be found independently, and of course, you could have opened the comments to find more links.
@jeffshaught7 ай бұрын
I do not have the ability to adjust swimlane size at all.
@Klong157 ай бұрын
I'm trying to broaden my development skills by utilizing UML diagrams more often, and I got Visio for a pretty cheap price. This was the first frustration I came across, haha. Thank you for the clear and easy solution!
@kenswindell97997 ай бұрын
Thank you, kind of a surprise.
@KarenTurner-u5k7 ай бұрын
Can you edit the Role Types to suit the organisation??
@1viggen0077 ай бұрын
i am trying to simply link and Excel Cell color(red) to a specific visio shape in drawing. Have read just about everything available but it still does not work. Any good simple reference that doesnt require VBA?
@bsmartbclearbvisual7 ай бұрын
Do you mean that you have Red as a text value in a cell? Or as RGB(255,0,0) ? Or as 2? "Red" will not work, but these other two could. However, you cannot go direct to the FillForegnd using Data Visualizer and need to via a Shape Data row. Have you reviewed my posts : bvisual.net/?s=DATA+Visualizer ?
@bsmartbclearbvisual6 ай бұрын
Or maybe bvisual.net/2022/04/18/update-any-visio-shapesheet-cell-with-external-data/
@ResumeCEO8 ай бұрын
Great stuff, Dave! Keep it coming!
@damianfrires66858 ай бұрын
How would I add the employees email and direct dial phone number data onto the employee graphic?
@bsmartbclearbvisual7 ай бұрын
Do you mean you want to see them on the Visio page? If so, if you have Visio Plan 2 then you can Edit in the desktop app to use Data Graphics.
@damianfrires66858 ай бұрын
How do I add the personal email or phone number to the org chart Visio shapess?
@bsmartbclearbvisual7 ай бұрын
Do you mean you want to see them on the Visio page? If so, if you have Visio Plan 2 then you can Edit in the desktop app to use Data Graphics.
@youonlytubeonce8 ай бұрын
Beautiful. Just what I needed! But I'm jealous. You had way better tool icons than I have. Version 2312 in M$365? Is there a place to import more of those?
@bsmartbclearbvisual7 ай бұрын
I probably get them slightly quicker than you....
@vorapobautomation97608 ай бұрын
Can you share the VB code please ?
@bsmartbclearbvisual7 ай бұрын
It is in the article....
@vorapobautomation97609 ай бұрын
How to display the object or shape name in text by just only click at the shape ?
@fsrslug9 ай бұрын
Is there any additional info on how to create this functionality available, specifically the process steps, navigation, and related links on the right side?
@bsmartbclearbvisual7 ай бұрын
It is a custom web page using the Visio web api learn.microsoft.com/en-us/office/dev/add-ins/reference/overview/visio-javascript-reference-overview
@vorapobautomation97609 ай бұрын
How to display the layer of object which import from .dxf file ?
@bsmartbclearbvisual7 ай бұрын
If you mean the layers within the embedded CAD object, then this is not exposed to the Visio ShapeSheet
@vorapobautomation97609 ай бұрын
How can import .dxf file into visio ? How to show line name and line layor color from CAD file in visio ?
@vorapobautomation97609 ай бұрын
How can import .dxf file into visio ? How to show line name and line layor color from CAD file in visio ?
@skyfellow49289 ай бұрын
Hi David, looks like great stuff and read your articles on the subject. But I'm not getting any audio with this video and looks like there should be some. My volume is on max and speakers/bluetooth working. Is it a silent movie?
@bsmartbclearbvisual9 ай бұрын
I just tried it ... there is sound but it is quite low
@equilibrio_esperanza9 ай бұрын
how do i resize the first vertical swimlane (function 1, 2, 3, ...)
@LeslieDias-u4q10 ай бұрын
Can it also be done for the format color for box on 1st page to box on second page.
@bsmartbclearbvisual6 ай бұрын
Certainly it can ... and it can be bi-directional! Details to follow soon ...
@sachinparab390810 ай бұрын
Amazing concept. Please guide us with sample data or file. It will help
@mikechivers11 ай бұрын
Good video, how did you get the report to show page number?
@masud-ahmed-cuet Жыл бұрын
changing in visio diagram, updates excel table; its awesome.
@rolandhernandez1213 Жыл бұрын
Is there a way to link two shapes where one inherits the shape data from the other, like a parent child relationship? In visio... thank you
@bsmartbclearbvisual7 ай бұрын
Yes there is, but you need add the ShapeSheet formulas such as =Sheet.123!Prop.MyData ... I suspect that you are looking for a less geeky way though?
@ShelliG Жыл бұрын
Would love to see more - I thought Visio integration was deprecated?
@bsmartbclearbvisual7 ай бұрын
I do hope not! The old Visio Web Access control was, but Visio support is in the new web modern part, and a colleague has improved this at unmanagedvisio.com/products/diagram-frame-sharepoint-visio-web-part/
@etleo3811 Жыл бұрын
Love it 🙌🏾❤️🙌🏾
@Brad-q4e Жыл бұрын
This was very informative and useful! I'm having a weird issue though when I close the Visio file I'm working on, these fields will no longer auto-update. I either have to Ctrl+drag to copy and the fields get updated in the new copy or I have to go to the insert field window again and just hit enter even though the custom formula is still there. Is there any way to auto-updating when I close and then open the file? Regardless, this has already saved me a bunch of time and super helpful!
@SomebodyFixDave Жыл бұрын
Hello David - thanks for putting together these great videos on the data visualizer. This to me is an amazing feature that has much potential if Microsoft continues to expand the functionality. A question i have that i am hoping you can help me with. I am using the Data Visualizer template for Basic Flowchart Shapes. I want to use the shape called Custom 4 in my flowchart, and since I will need to provide instructions to my users on how to use this, I will have to tell them to select Custom 4 in the Excel spreadsheet under Shape. Do you know, is there any way to rename this shape in the Visio Stencil ? It seems impossible to me to rename any of the shapes in the standard stencils. And it seems like the only option with the data visualizer is to use the standard stencils and no option to use custom stencils.
@Liceria_Meditation Жыл бұрын
Amazing do you have an instructional video on how you made the dashboard or can you provide the file and sample data. Nonetheless amazing work!!
@vukin Жыл бұрын
manual editing every shape, a nightmare
@bsmartbclearbvisual Жыл бұрын
But it is easy to atomically link all of the shapes to data, in one action, if you have text or a Shape Data value that can be used to match a column in your data source!
@MsHeritagegirl Жыл бұрын
I appreciate this tutorial. I have a question - I want to change the role types to reflect my organization's role types. I was excited to see I could just replace the temporary table1 with a new one. However, I understood that the employee ID had to also have a leader ID associated with it, in order for the chart to populate properly. I don't see an leader ID in your new chart. How did you get the associates to populate beneath their respective leaders without this? Thank you in advance for your help.
@bsmartbclearbvisual7 ай бұрын
The Structure tab has the minimum columns required to create the hierarchy. The Data tab contains the extra columns added to each Employee