Limiting the extent of the x-axis on a chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1567809%22%20slang%3D%22en-US%22%3ELimiting%20the%20extent%20of%20the%20x-axis%20on%20a%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1567809%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20placing%20data%20into%20an%20Excel%20spreadsheet%20to%20track%20blood%20pressure.%20When%20I%20chart%20(graph)%20the%20data%20the%20plot%20goes%20back%20to%20January%20even%20though%20the%20data%20I%20have%20selected%20for%20charting%20only%20goes%20as%20far%20back%20as%20June.%20This%20leads%20to%20a%20lower%20data%20resolution%20for%20the%20actual%20data%20I%20want%20to%20represent.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1567809%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-1570199%22%20slang%3D%22en-US%22%3ERe%3A%20Limiting%20the%20extent%20of%20the%20x-axis%20on%20a%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570199%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F750414%22%20target%3D%22_blank%22%3E%40RaykoonsTexas_309%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eset%20the%20minimum%20value%20in%20the%20chart%20to%20what%20ever%20value%20you%20want%3C%2FP%3E%3CP%3Esee%20the%20pic%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1571128%22%20slang%3D%22en-US%22%3ERe%3A%20Limiting%20the%20extent%20of%20the%20x-axis%20on%20a%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1571128%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746148%22%20target%3D%22_blank%22%3E%40ramizassaf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20taking%20the%20time%20to%20help%20me.%20ramizassaf!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERay%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am placing data into an Excel spreadsheet to track blood pressure. When I chart (graph) the data the plot goes back to January even though the data I have selected for charting only goes as far back as June. This leads to a lower data resolution for the actual data I want to represent.

2 Replies

@RaykoonsTexas_309 

 

set the minimum value in the chart to what ever value you want

see the pic

@Ramiz_Assaf 

 

Thank you for taking the time to help me. ramizassaf!

 

Ray