News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Using Fill Patterns with Data Graphics Color By Value

Started by Palouse, April 11, 2023, 10:26:12 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Palouse

Hello,

I tried referencing the information in this post: http://visguy.com/vgforum/index.php?topic=377.0
... and also this web page: https://bvisual.net/2008/03/17/using-fill-patterns-with-datagraphic-color-by-value/

I also posted a question on SuperUser, which has yet to receive any answers or comments. https://superuser.com/questions/1777635/using-fill-patterns-with-data-graphics-color-by-value-in-visio

I am painfully aware that the need for asking this question comes from a lack of experience and understanding about how the ShapeSheet works. I've been trying to read up on it the past few weeks and experimenting with solving this problem without asking a question, but haven't been able to.

Background: I am trying to link data from excel to a template in Viso that depicts the layout of an orchard and the species and variety planted. I am using Advanced Data Graphics --> Color By Value to apply a color to each plant based on a value in the spreadsheet, this has worked perfectly so far.

Problem: I would also like to apply a fill pattern to each shape based on a separate value from the spreadsheet.

For example, if the plant has a "Bi-axis" training style, it would have a green fill. If it is "Dead" it would have a crosshatch pattern (04).

From what I understand, the Fill Format cells on the ShapeSheet are automatically populated by the formulas in User-defined Cells, is this correct?

1) I am not sure of which cell in the Shape Sheet to enter the formula and also the proper syntax of the formula.
2) Is the "User.visDGCBVFill" cell the same cell I would enter the argument for the background pattern? Would it be nested within the existing formula?
3) Last, will the Legend update with the new background patterns?

I am happy to upload example pictures or specific examples from my project if it helps.

I am using Visio 2019 Professional

Yacine

Sorry, I have no time to elaborate on the solution, but watch the shapesheets of the shapes and the page in the attached drawing. I hope they are self explanatory.
Key points:
- Central list options at page level
- Targeting 3 fields in the shapes fillforegnd, fillbkgnd and pattern.
- User cells to get the color and pattern values from the props of the shape and the page.


HTH,
Y.
Yacine

Palouse

Quote from: Yacine on April 12, 2023, 10:43:01 AM
Sorry, I have not time to elaborate on the solution, but watch the shapesheets of the shapes and the page in the attached drawing.

Much appreciated! I will give it an in-depth look today!

Thank you

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 180 (show)
Files included: 35 - 1407KB. (show)
Memory used: 1058KB.
Tokens: post-login.
Cache hits: 14: 0.00349s for 26,722 bytes (show)
Cache misses: 4: (show)
Queries used: 17.

[Show Queries]