ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Value Axis Adjustment (https://www.excelbanter.com/excel-worksheet-functions/213585-value-axis-adjustment.html)

Workbook

Value Axis Adjustment
 
Thank you Jarek. I followed your advice and I made the major unit on the
Value (Y) axis scale 0.00347222222222222 to represent 5 min and it worked. I
still have one more question though. I have played around with the minimum,
maximum, and category (x) axis crosses at, fields but I have not been able to
get my chart to start the Value Axis at 5:30 AM, instead it starts at 4:10 AM
and wastes a lot of space on the chart. Do you know what field I should use
and what number I should enter so that the Value Axis begins at 5:30 AM?

Jarek Kujawa[_2_]

Value Axis Adjustment
 
why don't send me a file so I can have a look at it?


On 13 Gru, 17:20, Workbook wrote:
Thank you Jarek. *I followed your advice and I made the major unit on the
Value (Y) axis scale 0.00347222222222222 to represent 5 min and it worked.. *I
still have one more question though. *I have played around with the minimum,
maximum, and category (x) axis crosses at, fields but I have not been able to
get my chart to start the Value Axis at 5:30 AM, instead it starts at 4:10 AM
and wastes a lot of space on the chart. *Do you know what field I should use
and what number I should enter so that the Value Axis begins at 5:30 AM? *



Workbook

Value Axis Adjustment
 
Hi Jarek,

Thank you very much, you're input has been extremely helpful to me. I am
going to keep trying different inputs.

Thank you,

Eddie

"Jarek Kujawa" wrote:

why don't send me a file so I can have a look at it?


On 13 Gru, 17:20, Workbook wrote:
Thank you Jarek. I followed your advice and I made the major unit on the
Value (Y) axis scale 0.00347222222222222 to represent 5 min and it worked.. I
still have one more question though. I have played around with the minimum,
maximum, and category (x) axis crosses at, fields but I have not been able to
get my chart to start the Value Axis at 5:30 AM, instead it starts at 4:10 AM
and wastes a lot of space on the chart. Do you know what field I should use
and what number I should enter so that the Value Axis begins at 5:30 AM?





All times are GMT +1. The time now is 07:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com