Swatch Colors in Visio
6:30
9 ай бұрын
SS Plus May 2023
6:46
Жыл бұрын
SlideSnippetsInSitu
0:47
Жыл бұрын
WordPreviewsInSitu
2:12
Жыл бұрын
Linking Data to Visio Shapes
5:05
2 жыл бұрын
Overview of LayerManager
12:10
2 жыл бұрын
Export And Follow Links in Excel
0:24
Import Into Visio
0:29
2 жыл бұрын
Grid Snapping in Visio
0:18
2 жыл бұрын
DC Filter Matrix Rack
0:12
2 жыл бұрын
DC Filter Visio Rack
0:16
2 жыл бұрын
Create Link In SharePoint Online
0:23
Пікірлер
@yassertaher3091
@yassertaher3091 4 күн бұрын
lifesaver for summarizing that so quickly. Thanks
@TaniaKahtun-h7g
@TaniaKahtun-h7g 14 күн бұрын
Microprokey
@RedCoat999
@RedCoat999 19 күн бұрын
Can I change the headings of the Excel table? I want to use this style of chart but applied to different data.
@TaniaKahtun-h7g
@TaniaKahtun-h7g 29 күн бұрын
microprokey
@trevorlonewolf6406
@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
@francescomarzio5665
@francescomarzio5665 2 ай бұрын
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
@rahafal3787
@rahafal3787 2 ай бұрын
قصرت رجلك 🎉
@weihu2064
@weihu2064 2 ай бұрын
it doesn't work on 2021 pro
@carlosm5591
@carlosm5591 3 ай бұрын
Is it possible to insert the data of the field inside the rectangle. Thanks!!
@visu56141
@visu56141 3 ай бұрын
Sir how to get yellow point for user defined box will you please explain thank you sir
@robertnickel8849
@robertnickel8849 4 ай бұрын
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?
@rebeccaross1966
@rebeccaross1966 5 ай бұрын
This is great! I would love a tutorial for this!!! 🙋‍♀
@robmahony
@robmahony 5 ай бұрын
thanks boss.
@reyzox.9860
@reyzox.9860 6 ай бұрын
Just how to make the text grow synchronously with other forms ? thx
@reyzox.9860
@reyzox.9860 6 ай бұрын
Just how to make the text grow synchronously with other forms ? thx
@fpchd
@fpchd 6 ай бұрын
Thanks for you replies! I will implement your suggestions!
@fpchd
@fpchd 6 ай бұрын
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?
@bsmartbclearbvisual
@bsmartbclearbvisual 6 ай бұрын
You can create multiple queries using PowerQuery / Data | Get & Transfor Data, then use these for the source of different org charts on separate worksheets
@fpchd
@fpchd 6 ай бұрын
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.
@bsmartbclearbvisual
@bsmartbclearbvisual 6 ай бұрын
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
@fpchd
@fpchd 6 ай бұрын
@@bsmartbclearbvisual this worked very good! thanks again
@JanJensen-ec7xq
@JanJensen-ec7xq 6 ай бұрын
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?
@pcbecalette
@pcbecalette 6 ай бұрын
This was incredible! Thank you so much for sharing your knowledge! Best regards.
@brianching4358
@brianching4358 6 ай бұрын
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.
@bsmartbclearbvisual
@bsmartbclearbvisual 6 ай бұрын
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.
@jeffshaught
@jeffshaught 7 ай бұрын
I do not have the ability to adjust swimlane size at all.
@Klong15
@Klong15 7 ай бұрын
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!
@kenswindell9799
@kenswindell9799 7 ай бұрын
Thank you, kind of a surprise.
@KarenTurner-u5k
@KarenTurner-u5k 7 ай бұрын
Can you edit the Role Types to suit the organisation??
@1viggen007
@1viggen007 7 ай бұрын
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?
@bsmartbclearbvisual
@bsmartbclearbvisual 7 ай бұрын
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 ?
@bsmartbclearbvisual
@bsmartbclearbvisual 6 ай бұрын
Or maybe bvisual.net/2022/04/18/update-any-visio-shapesheet-cell-with-external-data/
@ResumeCEO
@ResumeCEO 8 ай бұрын
Great stuff, Dave! Keep it coming!
@damianfrires6685
@damianfrires6685 8 ай бұрын
How would I add the employees email and direct dial phone number data onto the employee graphic?
@bsmartbclearbvisual
@bsmartbclearbvisual 7 ай бұрын
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.
@damianfrires6685
@damianfrires6685 8 ай бұрын
How do I add the personal email or phone number to the org chart Visio shapess?
@bsmartbclearbvisual
@bsmartbclearbvisual 7 ай бұрын
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.
@youonlytubeonce
@youonlytubeonce 8 ай бұрын
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?
@bsmartbclearbvisual
@bsmartbclearbvisual 7 ай бұрын
I probably get them slightly quicker than you....
@vorapobautomation9760
@vorapobautomation9760 8 ай бұрын
Can you share the VB code please ?
@bsmartbclearbvisual
@bsmartbclearbvisual 7 ай бұрын
It is in the article....
@vorapobautomation9760
@vorapobautomation9760 9 ай бұрын
How to display the object or shape name in text by just only click at the shape ?
@fsrslug
@fsrslug 9 ай бұрын
Is there any additional info on how to create this functionality available, specifically the process steps, navigation, and related links on the right side?
@bsmartbclearbvisual
@bsmartbclearbvisual 7 ай бұрын
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
@vorapobautomation9760
@vorapobautomation9760 9 ай бұрын
How to display the layer of object which import from .dxf file ?
@bsmartbclearbvisual
@bsmartbclearbvisual 7 ай бұрын
If you mean the layers within the embedded CAD object, then this is not exposed to the Visio ShapeSheet
@vorapobautomation9760
@vorapobautomation9760 9 ай бұрын
How can import .dxf file into visio ? How to show line name and line layor color from CAD file in visio ?
@vorapobautomation9760
@vorapobautomation9760 9 ай бұрын
How can import .dxf file into visio ? How to show line name and line layor color from CAD file in visio ?
@skyfellow4928
@skyfellow4928 9 ай бұрын
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?
@bsmartbclearbvisual
@bsmartbclearbvisual 9 ай бұрын
I just tried it ... there is sound but it is quite low
@equilibrio_esperanza
@equilibrio_esperanza 9 ай бұрын
how do i resize the first vertical swimlane (function 1, 2, 3, ...)
@LeslieDias-u4q
@LeslieDias-u4q 10 ай бұрын
Can it also be done for the format color for box on 1st page to box on second page.
@bsmartbclearbvisual
@bsmartbclearbvisual 6 ай бұрын
Certainly it can ... and it can be bi-directional! Details to follow soon ...
@sachinparab3908
@sachinparab3908 10 ай бұрын
Amazing concept. Please guide us with sample data or file. It will help
@mikechivers
@mikechivers 11 ай бұрын
Good video, how did you get the report to show page number?
@masud-ahmed-cuet
@masud-ahmed-cuet Жыл бұрын
changing in visio diagram, updates excel table; its awesome.
@rolandhernandez1213
@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
@bsmartbclearbvisual
@bsmartbclearbvisual 7 ай бұрын
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
@ShelliG Жыл бұрын
Would love to see more - I thought Visio integration was deprecated?
@bsmartbclearbvisual
@bsmartbclearbvisual 7 ай бұрын
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
@etleo3811 Жыл бұрын
Love it 🙌🏾❤️🙌🏾
@Brad-q4e
@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
@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
@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
@vukin Жыл бұрын
manual editing every shape, a nightmare
@bsmartbclearbvisual
@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
@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.
@bsmartbclearbvisual
@bsmartbclearbvisual 7 ай бұрын
The Structure tab has the minimum columns required to create the hierarchy. The Data tab contains the extra columns added to each Employee