Using custom formulas with data graphics in pivot diagrams

[Tom]

I am using Visio2007 and have created a pivot diagram. I am trying to show a
progress data bar but the max value is the same for each item. e.g. If I
have 2 data columns (Target Revenue, Actual Revenue), how do I show the
actual as a progress on the target revenue for that specific item?

 

[Al Edlund]

There's been a great series of articles over on the Visio Insights Blog about
how to customize data graphics
http://blogs.msdn.com/visio/
al

 

[Mark Nelson [MS]]

You might use the multi-bar callout in order to enter two fields.

--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Tom]

Thanks Al! I picked up on the duplicate function which allowed me to set
each item differently. However, now when I refresh data to update the pivot
diagram, the data graphics revert back to some previous state. How do I make
the current graphics persist after data refresh? Thanks!

 

[Mark Nelson [MS]]

I believe you need to make sure that all the shapes in a given level have
the same data graphic.

--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.