Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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!!!!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
the cell refs at the top changed to numbers, how go back lettters | Excel Discussion (Misc queries) | |||
Going back from a hyperlink when it has changed to another workboo | Excel Discussion (Misc queries) | |||
how to get back excel data that was accidentally changed? | Excel Discussion (Misc queries) | |||
My files changed from A - Z to Z - A. How do I change this back? | Excel Discussion (Misc queries) | |||
Data changed in the back-up spreadsheet | Excel Discussion (Misc queries) |