Removing data point from a horizontal axis

%3CLINGO-SUB%20id%3D%22lingo-sub-918422%22%20slang%3D%22en-US%22%3ERemoving%20data%20point%20from%20a%20horizontal%20axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-918422%22%20slang%3D%22en-US%22%3E%3CP%3E%3CEM%3EHi%20All%2C%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EI%20am%20Quite%20new%20to%20this%20and%20require%20some%20help%20with%20removing%20data%20points%20from%20a%20horizontal%20axis%20see%20below.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F138374iE27FE4BE29F90C12%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20do%20i%20remove%20the%20underlined%20dates%2C%20i'm%20sourcing%20the%20data%20from%20a%20table%20where%20i%20have%20the%20dates%20on%20the%20cells%20and%20the%20data%20from%20the%20dates%20in%20columns%2C%20these%20dates%20are%20not%20in%20the%20table%20at%20all%20and%20never%20were.%20i%20cannot%20edit%20and%20add%20them%20nor%20remove%20them%20as%20they%20don't%20exist%20on%20the%20table%20but%20they%20show%20up%20here%20in%20my%20Graph.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-918422%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi All,

 

I am Quite new to this and require some help with removing data points from a horizontal axis see below.

clipboard_image_0.png

 

how do i remove the underlined dates, i'm sourcing the data from a table where i have the dates on the cells and the data from the dates in columns, these dates are not in the table at all and never were. i cannot edit and add them nor remove them as they don't exist on the table but they show up here in my Graph.

2 Replies

@Quentin280 

To do that, double click the horizontal axis to open the format horizontal axis window and make sure that the Text axis is selected for Axis Type. Refer to the image below...

 

AxisType.jpg

@Subodh_Tiwari_sktneer 

 

This Worked perfect, Thanks so much !!!