How do I reflect the x-axis exactly the same to the table?

%3CLINGO-SUB%20id%3D%22lingo-sub-2512754%22%20slang%3D%22en-US%22%3EHow%20do%20I%20reflect%20the%20x-axis%20exactly%20the%20same%20to%20the%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2512754%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20everyone!%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E1.%20%3CSTRONG%3EDevice%20and%20OS%20Platform%3C%2FSTRONG%3E%3A%20Mac%2FmacOS%20Big%20Sur%20version%2011.4%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E2.%20%3CSTRONG%3EExcel%20product%20name%20and%20version%20number%3C%2FSTRONG%3E%3A%20Office%20365%20and%2016.50(21061301)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E3.%20Question%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20want%20the%20x-axis%20of%20the%20chart%20reflects%20exactly%26nbsp%3Bthe%20same%20of%20what%20I%20have%20in%26nbsp%3Bthe%20table.%20Each%20row%20has%20different%20value.%20Hence%2C%20I%20would%26nbsp%3Bexpect%20a%20long%20x-axis.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EHowever%2C%20it%20is%20not%20reflecting%20what%20I%20needed%26nbsp%3Bright%26nbsp%3Bnow.%20I%20have%20attached%20the%20excel%20file%20in%20this%20post.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20there%20any%20kind%20soul%20could%20assist%20me%2C%20pls%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2512754%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2513299%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20reflect%20the%20x-axis%20exactly%20the%20same%20to%20the%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2513299%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1093640%22%20target%3D%22_blank%22%3E%40Roger1981%3C%2FA%3E%26nbsp%3BNot%20sure%20how%20your%20chart%20was%20created%2C%20but%20the%20data%20ranges%20seem%20to%20have%20been%20set%20wrong.%20Or%20I%20just%20don't%20understand%20what%20you%20are%20trying%20to%20do.%20Created%20a%20new%20chart%20with%20what%20I%20believe%20is%20what%20you%20need%2C%20though%20I%20did%20not%20format%20it%20to%20look%20like%20yours.%20Compare%20the%20data%20setting%20and%20see%20if%20mine%20work%20for%20your%20purpose.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2513308%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20reflect%20the%20x-axis%20exactly%20the%20same%20to%20the%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2513308%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1093640%22%20target%3D%22_blank%22%3E%40Roger1981%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20use%20scatter%20chart%20which%20doesn't%20work%20with%20text%20X-axis.%20However%2C%20in%20your%20case%20simple%20line%20chart%20gives%20the%20same%20plus%20correctly%20shows%20X-axis.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi everyone!

 

1. Device and OS Platform: Mac/macOS Big Sur version 11.4

2. Excel product name and version number: Office 365 and 16.50(21061301)

 

3. Question:

 

I want the x-axis of the chart reflects exactly the same of what I have in the table. Each row has different value. Hence, I would expect a long x-axis.

 

However, it is not reflecting what I needed right now. I have attached the excel file in this post.

 

Is there any kind soul could assist me, pls?

 

Thank you.

 

 

4 Replies

@Roger1981 Not sure how your chart was created, but the data ranges seem to have been set wrong. Or I just don't understand what you are trying to do. Created a new chart with what I believe is what you need, though I did not format it to look like yours. Compare the data setting and see if mine work for your purpose.

@Roger1981 

You use scatter chart which doesn't work with text X-axis. However, in your case simple line chart gives the same plus correctly shows X-axis.

Thank you. It’s solved now.
Thank you. It’s solved