kwarden13
asked on
Time Intervals on X axis PivotChart
Hi
I have a pivot chart w/ an x axis w/ times.
Example
4:30, 4:31, 4:32, etc.... going all the way up to 10pm
I want to know how to make it look clean
Right now its it trying to display every value which looks liek way too much on a graph.
If i group by hours it doesnt really do the trick. Maybe i can group by 15-30 min intervals?
Any suggstions?
I have a pivot chart w/ an x axis w/ times.
Example
4:30, 4:31, 4:32, etc.... going all the way up to 10pm
I want to know how to make it look clean
Right now its it trying to display every value which looks liek way too much on a graph.
If i group by hours it doesnt really do the trick. Maybe i can group by 15-30 min intervals?
Any suggstions?
SANTABABY
Could you please attach a sample?
Look at this article on how to use timescale values on the X-axis - one example for dates, and one example for times:
http://www.mrexcel.com/articles/excel-time-series-chart.php
I tried the procedure for the time values and was able to successfully set up a clean chart with time values on the x-axis. I used 15 minutes as the Major Unit (0.01042) and let it auto-pick the Minor Unit on the Scale tab. Use the directions to help determine the values for Minimum and Maximum based on your range of time values.
So although I had data for times such as 4:30, 4:31, 4:52, 5:05, 5:12, 6:27, 7:09 and 10:00, I had a chart with x-axis labels of 4:00, 4:15, 4:30, 4:45, etc. all the way to 10:00 and all the points plotted properly.
http://www.mrexcel.com/articles/excel-time-series-chart.php
I tried the procedure for the time values and was able to successfully set up a clean chart with time values on the x-axis. I used 15 minutes as the Major Unit (0.01042) and let it auto-pick the Minor Unit on the Scale tab. Use the directions to help determine the values for Minimum and Maximum based on your range of time values.
So although I had data for times such as 4:30, 4:31, 4:52, 5:05, 5:12, 6:27, 7:09 and 10:00, I had a chart with x-axis labels of 4:00, 4:15, 4:30, 4:45, etc. all the way to 10:00 and all the points plotted properly.
My comment was for controlling the x-axis labels. If you really do have a data point for every minute, what I did doesn't address all the plotted values in the chart, but cleans up the x-axis. Sorry if I misunderstood.
ASKER
Attached is a sample
TestBook.xls
TestBook.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.