Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
AutomaticScale doesn't work properly
Hi all
a question a fellow employee has asked me earlyer: I have two identic formatted tables, with each 2 columns 1. Column contains each Month of the last 3 years 2. Column contains Data, normal numbers without link or whatever first table ranges from 98.8 to 109.3 second table from 100 to 136 Now i'm going to do two chart from those two tables: first table changes into a chart where the minimum is automatically set to 92, second table however has a minimum of 0!?? even when i change some of the numbers it stays like that! What points does excel take into consideration for calculating the minimum or maximum points of charts? This problem freaks me out!! Cheers Carlo |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
AutomaticScale doesn't work properly
If the difference between high and low is more than about 1/6 of the value
of the high, Excel extends the axis all the way down to 0. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Carlo" wrote in message ... Hi all a question a fellow employee has asked me earlyer: I have two identic formatted tables, with each 2 columns 1. Column contains each Month of the last 3 years 2. Column contains Data, normal numbers without link or whatever first table ranges from 98.8 to 109.3 second table from 100 to 136 Now i'm going to do two chart from those two tables: first table changes into a chart where the minimum is automatically set to 92, second table however has a minimum of 0!?? even when i change some of the numbers it stays like that! What points does excel take into consideration for calculating the minimum or maximum points of charts? This problem freaks me out!! Cheers Carlo |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
AutomaticScale doesn't work properly
That's an answer i was looking for :)
and as usual it's you that provides it! Thank you Carlo "Jon Peltier" wrote: If the difference between high and low is more than about 1/6 of the value of the high, Excel extends the axis all the way down to 0. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Carlo" wrote in message ... Hi all a question a fellow employee has asked me earlyer: I have two identic formatted tables, with each 2 columns 1. Column contains each Month of the last 3 years 2. Column contains Data, normal numbers without link or whatever first table ranges from 98.8 to 109.3 second table from 100 to 136 Now i'm going to do two chart from those two tables: first table changes into a chart where the minimum is automatically set to 92, second table however has a minimum of 0!?? even when i change some of the numbers it stays like that! What points does excel take into consideration for calculating the minimum or maximum points of charts? This problem freaks me out!! Cheers Carlo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated work! Any idea?? | Excel Worksheet Functions | |||
Summarizing field quantities for specific records | Excel Worksheet Functions | |||
How to copy the work sheets from different workbooks into one? | Excel Discussion (Misc queries) | |||
How do I make 'save as web page' with interactivity work properly. | Charts and Charting in Excel | |||
The colors should work properly in Shared Excel Workbooks. | Excel Worksheet Functions |