Hello all,

Working on a productivity analysis spreadsheet that measures movements in seconds and does some summation. There is a ton of data from April-YTD and depending on what time frame I am looking at, I want it to adjust the Y-axis for me into something that is logical. For example, if I am looking at it for a day, it ranges from 1 hour to 3.5 hours. No problem there, data looks fantastic! However, if I want to look at it over a week or month, it makes no sense at all. It will start at 30days, then moving up along the y-axis, it will go to 1 day and then at the top, it will say 3 days. If I filter it my different months, it will continue to give me confusing data.

I have spent hours adjusting the number format option under value field settings, using various suggestions for "custom" and I still can't get it to show how I want it to.

Any thoughts?

Thanks,