Data bar misplacement after database is updated

Question

Hello,

I will try to describe my issue as well as possible (I'm a forum newbie). Since "well" is relative, I'm open for any constructive criticism. I tried my chance on visguy but no responses yet.

Visio Version:

• Visio 2016 MSO
• Language: German

What I'm trying to build:
I want to display data from an Excel sheet by using Visio. To do so, I have imported the data in Visio and have created stencils for different data sets. The stencils have been set up to contain the needed data and to display them by using advanced data graphics. Each advanced data graphic is used for one and only one master stencil.
After linking the data to the corresponding stencil manually (a certain master stencil for the corresponding data set), all the shapes and their respective data seem to be displayed in the correct way (see picture "BeforeUpdating.jpg").

The issue(s):
The values of the excel sheet are meant to change. After updating the data, most of it is displayed correctly... except for the data bars (see picture "AfterUpdating.jpg")
After digging the problem, I have observed the following facts:

• The data value is correct, only the display is off
• When a specific shape (with the wrongly displayed data) is deleted and newly linked with the master stencil, the data layout is displayed properly.
• The data bar max. value changes after the update. This value is initially set to 1 for every data graphic.
• The data bars on the left of the rectangle are set the same way as the ones on the right (in the AdvancedDataGraphics), but the ones on the right get put above one another after updating the data.

I must be doing something wrong, any hints on how to fix the issue?
Thank you in Advance!

Before updating:

After updating:

Answer 1

@Lolo1313 ,
According to your description, I ran a simple test on Visio 2016, but I did not encounter any issues, please check it out.

Since this issue occured randomly, the cause of the problem cannot be determined currently. I have the following information and want to confirm with you at your convenience.

1. Is there a problem after only importing the Excel file? What is the extension of this file?
2. When changed the values of Excel table, does the Visio file close? Please save and close all files, and restart your PC to have a check.
3. Which template was used to create the Visio file? Please use other templates to check this issue.

Per my research, please try the following steps to check the problem.

• Try to edit the data bar.
• Create a new Visio file and create a simple data set to check if this problem exists.

If the above do not work, I also suggest you try to open the Visio in safe mode to check this issue.

Any updates, please let me know.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.