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.
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,087
Messages
5,835,302
Members
430,351
Latest member
ddalton

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