Need Military Time In Chart

[90Shilling]

I need military time on the x axis, It needs to start at 0 and go to 24, i can only get it to go from 1 to 24, but this would lose an hour. The the "fall time" I need in an area chart.

Any help is appreciated

[MrShorty]

I'm not sure I understand what you are trying to get, but I will venture some thoughts.

I need military time on the x axis, It needs to start at 0 and go to 24, i can only get it to go from 1 to 24

I note that your chart type is a line chart and that you have not specified a range for the category axis labels, so it is simply using the numbers 1 to 24. These are simple numbers and do not represent time in any way. The only chart type I know of that will natively support time along the x axis is a scatter chart, where you would specify that column A is the x axis values.

Of course, then I look closer at the values you have in column A, and these are not just time values. They are formatted to only show the time portion of the value (in 24 hour format), but the cells contain both date and time information, and the date information seems meaningless. What do the values in column A actually represent? What are they supposed to represent? I would expect the time values to be from 0 to 24 hours (so the underlying value is from 0 to 1).

The the "fall time" I need in an area chart

An area chart is not going to support a time axis. Depending on exactly what you are trying to do, this might require a combination XY scatter + area -- the scatter chart to show the time value points and the area chart to "fill" in the space below the scatter chart series. See procedure here: https://peltiertech.com/fill-under-b...n-excel-chart/

Does that help any?

[90Shilling]

I see what you are saying, dont have time to mess with it right now but will let you know. Time of Fall are specific times which an event took place. trying to figure out the high risk times. TY for your help.