smartart

Hi All, I currently have a VBA macro in excel that is creating and populating a SmartArt Organisation Hierarchy, I want to have another macro afterwards that then changes the layout to a different one. In my mind this is possible, but I am a shambles when it comes to VBA! Any help will do...

Hi all! Have to start with a big thank you! I have learnt so much from this forum and wish to contribute in some way in the future! I have been lurking far to long with out creating an account. To the problem at hand: I'm building a tool to follow up activities/tasks I have a table (tabell1)...

I've been building up an organizational chart for where I work using the Excel SmartArt. Currently I'm using the Name and Title template. I was wondering if it is possible to somehow add additional titles to all the boxes. Below is a quick example similar to what I currently have built up. I'm...

Hello! I would like to show a message box with the text of each node clicked on my smartart. I would like to return the node text and not the main object text. I tried using Application.Caller and it didn't work Help would be much appreciated! :)

Hi, I have formed a process using SmartArt and would like to add icons to the chart area, which works fine! But, when copying or marking in order to move or resize, icons are not following. Is there any work arounds on this issue?

I dynamically generate Org Charts using the SmartArt CirclePictureHierarchy object, but I am unable to export them as PDF files in code. I thought I could use the same code as I use to export a Chart, but that didn't work. I believe exporting Shapes is doable, but I can't capture the code in a...

I have a dashboard that I am trying to make nicer than just cell sized boxes. Is there anyway I can add formulas to SmartArt? I am using excel 2013

Hi all, I've managed to write some code that converts a list of people (with column headings: Name, Title, No of People, Manager) into a hierarchy SmartArt object. The code also formats each of the nodes (the forecolor, the box outline and the text color). The issue is that there are lines that...

Hi, I have generated a code to automatically fill up a Smartart with data from some cells. The remaining point is how to add also hyperlink to the smartart nodes. This can be done in excel by right clicking. But I want to this to be also automatic. The cells from which the data is generated do...

I am working with Excel for Mac 2011. In the SmartArt section they have a picture tab, where you can select from various formats. None of these formats fit my needs. So my question is, can I customize these? If not, can I add a macro to a shape so that it can do what the picture boxes do...

I am working with Excel for Mac 2011. In the SmartArt section they have a picture tab, where you can select from various formats. None of these formats fit my needs. So my question is, can I customize these? If not, can I add a macro to a shape so that it can do what the picture boxes do...

Hi Experts, After checking the forum I found what appears to be perfect for my needs but not able to get this VBA private sub to run (or it's simply not doing anything that I can see). I have taken the code from this post (I'm using Excel 2010), My set-up is as follows, Open new Excel...

Hi All, Does anyone know of a way to dynamically link Smart Art (especially hierarchy charts like an org chart) to a Pivot Table? If not a Pivot Table then just a normal set of data in a worksheet, so when the data changes the Smart Art changes accordingly. Many Thanks Don Johannesburg