View Full Version : [SOLVED:] Error with progress bar chart
Hugh Bomford
01-01-2022, 10:15 PM
In order to make a visual representation of our society's progress towards our target membership I carried out research and found The Spreadsheet Guru who gives you access to base files. I downloaded the attached one which suits my needs. The only problem is that once you enter a value in excess of 83% the chart has an error and the progress bar reduces in length instead of extending. This error carries on up to 99%. Can anyone help to correct this. I have attached the sample sheet. Thanks in advance
Paul_Hossler
01-02-2022, 09:04 PM
Excel is trying to be helpful by adjusting the max/min values of the axis
Since axes were not displayed, it didn't show
Easy fix
1. Add Axes
2. Change Min to 0
3. Remove Axes
29274
29275
29276
https://superuser.com/questions/1149758/powerpoint-stacked-bar-chart-with-wrong-bar-length
Hugh Bomford
01-03-2022, 10:37 AM
Hi Paul. Thank you very much for solving this for me. All the very best to you for 2022.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.