If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Link a cell to min & max box for Value (X) axis scale? | cwilliams | Charts and Charting | 2 | June 6th, 2005 09:19 PM |
Problem with date base units for x axis | Peter Carr | Charts and Charting | 1 | December 15th, 2004 09:11 AM |
How do I change scope of Y axis scale in MS excel graphs | JLEPG | General Discussion | 1 | November 7th, 2004 03:20 AM |
Value Axis Scale Change Problem | dp_fulcher | Charts and Charting | 1 | October 19th, 2004 01:21 PM |
Value Axis Change Problem in Chart | dp_fulcher | General Discussion | 1 | October 19th, 2004 03:01 AM |