SOLVED

Axis options in a line diagram.

%3CLINGO-SUB%20id%3D%22lingo-sub-3322164%22%20slang%3D%22en-US%22%3EAxis%20options%20in%20a%20line%20diagram.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3322164%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20MS%20365%20and%20doing%20a%20standard%20line%20diagram%20with%20a%20date%20axis.%20Why%20does%20the%20Axis%20Options%20differ%20between%20diagrams%20in%20individual%20sheets%20of%20the%20same%20work%20book%3F%3C%2FP%3E%3CP%3EIn%20some%20sheets%20the%20Axis%20Options%20comprise%20%3CSTRONG%3Efive%3C%2FSTRONG%3E%20groups%20of%20settings%20(type%2C%20bounds%2C%20units%2C%20vertical%20crosses%2C%20position)%20but%20in%20other%20sheets%20the%20Axis%20Options%20comprise%20only%20%3CSTRONG%3Ethree%3C%2FSTRONG%3E%20groups%20and%20with%20%3CSTRONG%3Etwo%3C%2FSTRONG%3E%20groups%20%3CSTRONG%3Emissing%3C%2FSTRONG%3E%20(bounds%20and%20units%20are%20missing).%20Why%3F%3C%2FP%3E%3CP%3EI%20do%20need%20to%20use%20the%20bounds%20and%20units%20settings%20to%20make%20my%20diagram%20look%20right.%20Is%20there%20a%20way%20to%20access%20the%26nbsp%3Bbounds%20and%20units%20settings%20when%20they%20do%20not%20show%20up%20automatically%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3322164%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3322655%22%20slang%3D%22en-US%22%3ERe%3A%20Axis%20options%20in%20a%20line%20diagram.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3322655%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Hans%2C%20Thanks%20for%20the%20input.%20My%20axis%20are%20all%20of%20type%20date%20axis%20however.%3C%2FP%3E%3CP%3EI%20will%20try%20to%20share%20a%20screen%20shot%20showing%20date%20axis%20but%20without%20the%20Bounds%20and%20Units%20settings.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1381786%22%20target%3D%22_blank%22%3E%40Jan_Altena%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3323060%22%20slang%3D%22en-US%22%3ERe%3A%20Axis%20options%20in%20a%20line%20diagram.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3323060%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1381786%22%20target%3D%22_blank%22%3E%40Jan_Altena%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOr%20better%3A%3C%2FP%3E%0A%3CP%3ECould%20you%20attach%20a%20sample%20workbook%20(without%20sensitive%20data)%2C%20or%20if%20that%20is%20not%20possible%2C%20make%20it%20available%20through%20OneDrive%2C%20Google%20Drive%2C%20Dropbox%20or%20similar%3F%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3322206%22%20slang%3D%22en-US%22%3ERe%3A%20Axis%20options%20in%20a%20line%20diagram.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3322206%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1381786%22%20target%3D%22_blank%22%3E%40Jan_Altena%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20it%20be%20the%20difference%20between%20a%20date%20axis%20and%20a%20text%20axis%20(with%20dates%20treated%20as%20text)%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S1402.png%22%20style%3D%22width%3A%20573px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369433iD5A56800BA4B6F1F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S1402.png%22%20alt%3D%22S1402.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3324541%22%20slang%3D%22en-US%22%3ERe%3A%20Axis%20options%20in%20a%20line%20diagram.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3324541%22%20slang%3D%22en-US%22%3EHi%20Hans%2C%3CBR%20%2F%3ELink%20to%20sample%20file%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1N93MCNbc6SwaF_5QNv1GcGbAygMASw9x%2Fedit%3Fusp%3Dsharing%26amp%3Bouid%3D101398242242417236273%26amp%3Brtpof%3Dtrue%26amp%3Bsd%3Dtrue%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1N93MCNbc6SwaF_5QNv1GcGbAygMASw9x%2Fedit%3Fusp%3Dsharing%26amp%3Bouid%3D101398242242417236273%26amp%3Brtpof%3Dtrue%26amp%3Bsd%3Dtrue%3C%2FA%3E%3CBR%20%2F%3EThe%20axis%20options%20in%20sheet%20%2222_chart%22%20includes%20the%20Bounds%20and%20Units%20settings%20but%20in%20sheet%20%22Sheet1%22%20those%20settings%20are%20not%20included.%3CBR%20%2F%3EDo%20you%20know%20of%20a%20way%20to%20access%20the%20Bounds%20and%20Units%20settings%20in%20%22Sheet1%22%2C%20please%3F%3CBR%20%2F%3EGreetings%20from%20G%C3%B6teborg%2C%20Sweden%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3324827%22%20slang%3D%22en-US%22%3ERe%3A%20Axis%20options%20in%20a%20line%20diagram.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3324827%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1381786%22%20target%3D%22_blank%22%3E%40Jan_Altena%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%20that%20helps.%3C%2FP%3E%0A%3CP%3EThe%20x-axis%20values%20in%20Sheet1%2C%20range%20A4%3AA27%20are%20left-aligned%2C%20indicating%20that%20Excel%20sees%20them%20as%20text%20values.%3C%2FP%3E%0A%3CP%3ESelect%20A4%3AA27.%3C%2FP%3E%0A%3CP%3EOn%20the%20Data%20tab%20of%20the%20ribbon%2C%20click%20Text%20to%20Columns.%3C%2FP%3E%0A%3CP%3EClick%20Next%20%26gt%3B%20twice.%3C%2FP%3E%0A%3CP%3ESelect%20YMD%20from%20the%20drop-down%20next%20to%20Date.%3C%2FP%3E%0A%3CP%3EClick%20Finish.%3C%2FP%3E%0A%3CP%3EIf%20all%20goes%20well%2C%20the%20values%20will%20now%20be%20right-aligned.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S1404.png%22%20style%3D%22width%3A%20276px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369492iF30C87672A83D5C6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S1404.png%22%20alt%3D%22S1404.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20you%20now%20double-click%20the%20x-axis%2C%20you%20should%20see%20all%20sections.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3328175%22%20slang%3D%22en-US%22%3ERe%3A%20Axis%20options%20in%20a%20line%20diagram.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3328175%22%20slang%3D%22en-US%22%3EHello%20Hans%2C%3CBR%20%2F%3EThank%20you%20very%20much%20for%20solving%20my%20problem.%3CBR%20%2F%3EYou%20provided%20me%20with%20a%20very%20useful%20lesson%20into%20yet%20another%20aspect%20of%20Excel.%3C%2FLINGO-BODY%3E
New Contributor

I am using MS 365 and doing a standard line diagram with a date axis. Why does the Axis Options differ between diagrams in individual sheets of the same work book?

In some sheets the Axis Options comprise five groups of settings (type, bounds, units, vertical crosses, position) but in other sheets the Axis Options comprise only three groups and with two groups missing (bounds and units are missing). Why?

I do need to use the bounds and units settings to make my diagram look right. Is there a way to access the bounds and units settings when they do not show up automatically?

6 Replies

@Jan_Altena 

Could it be the difference between a date axis and a text axis (with dates treated as text)?

S1402.png

Hi Hans, Thanks for the input. My axis are all of type date axis however.

I will try to share a screen shot showing date axis but without the Bounds and Units settings.

@Jan_Altena 

@Jan_Altena 

Or better:

Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.

Hi Hans,
Link to sample file: https://docs.google.com/spreadsheets/d/1N93MCNbc6SwaF_5QNv1GcGbAygMASw9x/edit?usp=sharing&ouid=10139...
The axis options in sheet "22_chart" includes the Bounds and Units settings but in sheet "Sheet1" those settings are not included.
Do you know of a way to access the Bounds and Units settings in "Sheet1", please?
Greetings from Göteborg, Sweden
best response confirmed by Grahmfs13 (Microsoft)
Solution

@Jan_Altena 

Thanks, that helps.

The x-axis values in Sheet1, range A4:A27 are left-aligned, indicating that Excel sees them as text values.

Select A4:A27.

On the Data tab of the ribbon, click Text to Columns.

Click Next > twice.

Select YMD from the drop-down next to Date.

Click Finish.

If all goes well, the values will now be right-aligned.

S1404.png

If you now double-click the x-axis, you should see all sections.

Hello Hans,
Thank you very much for solving my problem.
You provided me with a very useful lesson into yet another aspect of Excel.