Problem with Chart Increments

Leofan7

New Member
Joined
Nov 11, 2005
Messages
2
Tis is my first time here, and I'm glad to be here. I've been a fan of Leo and CFH for a long time and I've grown to respect Mr. Excel. Anyway, back to my question.

I'm in a Computer Applications competition here in Texas and I've had a problem with one of my practice tests that not even my teachers can figure out.

I have a spreadsheet (duh) that has a column of times. I am instructed to make a chart with these times on the y axis in 6 hour increments. I've played around with the scale tab on the Format Axis command, but to no avail. These times need to be 12:00AM, 6:00AM, 12:00PM, 6:00PM, and 12:00AM. I will try to get links up so you all can at least see what I'm talking about, since it's pretty hard to explain in words. In the meantime ya'll can give me some stuff to tinker with. Thanks for your help in advance.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

andy3816

Board Regular
Joined
Mar 22, 2005
Messages
135
I dont think this can be done, even though excel calls it a time axis it really is a date axis
 

Watch MrExcel Video

Forum statistics

Threads
1,122,487
Messages
5,596,450
Members
414,068
Latest member
FAH

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top