I changed value scale numbers - goes back to what program wants?
I have a range of percentage data values ranging from 97% to 100% and the
chart starts the bar graph at 97%. I tried to override the "scale" numbers but it goes back to start at 97%. I want it to start at 0% up to 100%. The only way I can get it to start at 0% is to put a value in the data table of 0% but then it shows on graph and I don't want that. Why when I change the minimum to 0 and max to 1 if refused to take it. It did not do this is the old 97 version of excel!!! thanks!!!!! |
I changed value scale numbers - goes back to what program wants?
After you enter a value, don't check the Auto box. Auto means let Excel
decide what to use. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dizzyizzy" wrote in message ... I have a range of percentage data values ranging from 97% to 100% and the chart starts the bar graph at 97%. I tried to override the "scale" numbers but it goes back to start at 97%. I want it to start at 0% up to 100%. The only way I can get it to start at 0% is to put a value in the data table of 0% but then it shows on graph and I don't want that. Why when I change the minimum to 0 and max to 1 if refused to take it. It did not do this is the old 97 version of excel!!! thanks!!!!! |
All times are GMT +1. The time now is 12:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com