Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y Axis Scale Problem
Hello. I'm making a chart that shows me the times between entries in another
worksheet. Thusfar everything works find but I noticed that there is the occational drought of entries and the time goes from averaging around fifteen minutes to a couple of hours. Especially during lunch. Is there a way I can get the Y axis to increase the Major unit the higher in the scale a point is. Something where I can have on hour take up half the total Y axis and the second hour take up another half or third and so on so I can put a nine hour workday on the scale and still have everything look somewhat normal. If any of you have any ideas how I could do this it would be greatly appreciated. Thank you |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y Axis Scale Problem
Sounds like a job for a log scale.
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Abode" wrote in message ... Hello. I'm making a chart that shows me the times between entries in another worksheet. Thusfar everything works find but I noticed that there is the occational drought of entries and the time goes from averaging around fifteen minutes to a couple of hours. Especially during lunch. Is there a way I can get the Y axis to increase the Major unit the higher in the scale a point is. Something where I can have on hour take up half the total Y axis and the second hour take up another half or third and so on so I can put a nine hour workday on the scale and still have everything look somewhat normal. If any of you have any ideas how I could do this it would be greatly appreciated. Thank you |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y Axis Scale Problem
Log scale. Like Logrithmic Scale. I tried to do that but It gave me an
error. In between days I have a blank entry with no values for the X and Y to display there is a new day and also insure that the scale doesn't show around an 800 minute gap inbetween entries. I think since either that or the fact that I have the first entries of the day start a 0(Y) minutes making the Y axis logrithmic wont work. The First entry of the day starting at 0 is an easy fix since I can have the program automatically set it to .5 minutes or something like that. But what about the blank entries for a new day?!. "Jon Peltier" wrote: Sounds like a job for a log scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Abode" wrote in message ... Hello. I'm making a chart that shows me the times between entries in another worksheet. Thusfar everything works find but I noticed that there is the occational drought of entries and the time goes from averaging around fifteen minutes to a couple of hours. Especially during lunch. Is there a way I can get the Y axis to increase the Major unit the higher in the scale a point is. Something where I can have on hour take up half the total Y axis and the second hour take up another half or third and so on so I can put a nine hour workday on the scale and still have everything look somewhat normal. If any of you have any ideas how I could do this it would be greatly appreciated. Thank you |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y Axis Scale Problem
Easy - don't skip blank rows. And since the first one isn't coming "after"
another, don't even list it. One way to hide these points without rearranging the data range is to insert this formula =NA() into a cell that would otherwise show zero or a blank. The point doesn't appear, and Excel doesn't keep reminding you about zeros and logs and all that. This leaves an ugly #N/A error in the cell, but you can use conditional formatting to hide the error. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Abode" wrote in message ... Log scale. Like Logrithmic Scale. I tried to do that but It gave me an error. In between days I have a blank entry with no values for the X and Y to display there is a new day and also insure that the scale doesn't show around an 800 minute gap inbetween entries. I think since either that or the fact that I have the first entries of the day start a 0(Y) minutes making the Y axis logrithmic wont work. The First entry of the day starting at 0 is an easy fix since I can have the program automatically set it to .5 minutes or something like that. But what about the blank entries for a new day?!. "Jon Peltier" wrote: Sounds like a job for a log scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Abode" wrote in message ... Hello. I'm making a chart that shows me the times between entries in another worksheet. Thusfar everything works find but I noticed that there is the occational drought of entries and the time goes from averaging around fifteen minutes to a couple of hours. Especially during lunch. Is there a way I can get the Y axis to increase the Major unit the higher in the scale a point is. Something where I can have on hour take up half the total Y axis and the second hour take up another half or third and so on so I can put a nine hour workday on the scale and still have everything look somewhat normal. If any of you have any ideas how I could do this it would be greatly appreciated. Thank you |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y Axis Scale Problem
I tried putting in the =NA() into the cells the chart reads but it still
connects the lines. "Jon Peltier" wrote: Easy - don't skip blank rows. And since the first one isn't coming "after" another, don't even list it. One way to hide these points without rearranging the data range is to insert this formula =NA() into a cell that would otherwise show zero or a blank. The point doesn't appear, and Excel doesn't keep reminding you about zeros and logs and all that. This leaves an ugly #N/A error in the cell, but you can use conditional formatting to hide the error. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Abode" wrote in message ... Log scale. Like Logrithmic Scale. I tried to do that but It gave me an error. In between days I have a blank entry with no values for the X and Y to display there is a new day and also insure that the scale doesn't show around an 800 minute gap inbetween entries. I think since either that or the fact that I have the first entries of the day start a 0(Y) minutes making the Y axis logrithmic wont work. The First entry of the day starting at 0 is an easy fix since I can have the program automatically set it to .5 minutes or something like that. But what about the blank entries for a new day?!. "Jon Peltier" wrote: Sounds like a job for a log scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Abode" wrote in message ... Hello. I'm making a chart that shows me the times between entries in another worksheet. Thusfar everything works find but I noticed that there is the occational drought of entries and the time goes from averaging around fifteen minutes to a couple of hours. Especially during lunch. Is there a way I can get the Y axis to increase the Major unit the higher in the scale a point is. Something where I can have on hour take up half the total Y axis and the second hour take up another half or third and so on so I can put a nine hour workday on the scale and still have everything look somewhat normal. If any of you have any ideas how I could do this it would be greatly appreciated. Thank you |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y Axis Scale Problem
NA() is not quite the same as a blank. It displays lines in a series that is
formatted with lines. If you need to show a gap, you can try the technique on Andy Pope's web site: http://andypope.info/charts/brokenlines.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Abode" wrote in message ... I tried putting in the =NA() into the cells the chart reads but it still connects the lines. "Jon Peltier" wrote: Easy - don't skip blank rows. And since the first one isn't coming "after" another, don't even list it. One way to hide these points without rearranging the data range is to insert this formula =NA() into a cell that would otherwise show zero or a blank. The point doesn't appear, and Excel doesn't keep reminding you about zeros and logs and all that. This leaves an ugly #N/A error in the cell, but you can use conditional formatting to hide the error. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Abode" wrote in message ... Log scale. Like Logrithmic Scale. I tried to do that but It gave me an error. In between days I have a blank entry with no values for the X and Y to display there is a new day and also insure that the scale doesn't show around an 800 minute gap inbetween entries. I think since either that or the fact that I have the first entries of the day start a 0(Y) minutes making the Y axis logrithmic wont work. The First entry of the day starting at 0 is an easy fix since I can have the program automatically set it to .5 minutes or something like that. But what about the blank entries for a new day?!. "Jon Peltier" wrote: Sounds like a job for a log scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Abode" wrote in message ... Hello. I'm making a chart that shows me the times between entries in another worksheet. Thusfar everything works find but I noticed that there is the occational drought of entries and the time goes from averaging around fifteen minutes to a couple of hours. Especially during lunch. Is there a way I can get the Y axis to increase the Major unit the higher in the scale a point is. Something where I can have on hour take up half the total Y axis and the second hour take up another half or third and so on so I can put a nine hour workday on the scale and still have everything look somewhat normal. If any of you have any ideas how I could do this it would be greatly appreciated. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a problem to properly display the title of Value (Y) axis i | Charts and Charting in Excel | |||
create a scale x axis that matches the straighted form of a norma. | Charts and Charting in Excel | |||
Is there a way to get log scale on the x axis? | Charts and Charting in Excel | |||
Locking the scale ratio of X-Y axis in XY scatter charts | Charts and Charting in Excel | |||
Change the value axis scale | Charts and Charting in Excel |