Loading...
Quick Links

Reply To: Automatic formatting and progress bar format

Home Forums Discussion Automatic formatting and progress bar format Reply To: Automatic formatting and progress bar format

#362452
Thomas Boyle
Guest

Hi Chris,
The layering of the bar chart objects occurs according to (the reverse of) their order in the bar styles list; i.e. those bar styles at the bottom of the list will appear superposed on the other layers. For your case, use the mouse to point at a blank area of the bar chart pane, then right click and select “bar styles”. Then find your progress bar, “cut row”, and paste it below the other bar that is in the way.

If your “auto-format” bar is being routinely added by VBA or other code, then you may need to revise that code to ensure the order you want.

Good luck, tom