Home

XY scatter

%3CLINGO-SUB%20id%3D%22lingo-sub-752724%22%20slang%3D%22en-US%22%3EXY%20scatter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752724%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20doing%20an%20XY%20scatter%20graph%20that%20shows%20data%20for%20a%20span%20of%2020%20years.%26nbsp%3B%20However%2C%20when%20the%20graph%20is%20made%2C%20the%20x-axis%20timeline%20goes%20all%20the%20way%20back%20to%201900.%26nbsp%3B%20How%20do%20you%20adjust%20the%20timeline%20to%20only%20focus%20on%20my%20selected%20time%20frame%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-752724%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752943%22%20slang%3D%22en-US%22%3ERe%3A%20XY%20scatter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752943%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F375576%22%20target%3D%22_blank%22%3E%40rchase1101%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20easiest%20fix%20might%20be%20to%20try%20a%20line%20chart%20rather%20than%20a%20scatter%20chart.%20Line%20charts%20understand%20dates%20and%20times.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20still%20want%20to%20use%20a%20scatter%20chart%2C%20then%20you%20need%20to%20change%20the%20X-axis%20minimum%20scale%20to%20a%20reasonable%20value.%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EEnter%20the%20desired%20minimum%20and%20maximum%20dates%20in%20two%20blank%20cells%3C%2FLI%3E%0A%3CLI%3EFormat%20those%20cells%20with%20Number%20format%20and%20no%20decimal%20places%3C%2FLI%3E%0A%3CLI%3ERightclick%20the%20X-axis%20on%20your%20chart%2C%20then%20choose%20Format%20axis%20from%20the%20resulting%20popup%3C%2FLI%3E%0A%3CLI%3EGo%20to%20the%20Text%20tab%20in%20the%20resulting%20task%20pane%20by%20clicking%20the%20green%20column%20chart%20icon%3C%2FLI%3E%0A%3CLI%3EYou%20will%20be%20entering%20the%20numbers%20from%20step%202%20in%20the%20Minimum%20and%20Maximum%20scale%20fields.%20These%20appear%20to%20have%20been%20renamed%20Minimum%20and%20Maximum%20Bounds%20in%20my%20Office%20Insider%20copy%20of%20Excel%202016%2FOffice%20365.%3C%2FLI%3E%0A%3CLI%3EYou%20may%20also%20want%20to%20change%20the%20Major%20Units%20to%2030.5%20to%20display%20your%20dates%20along%20the%20axis%20in%20roughly%20one%20month%20increments.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20548px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123191i4FD7A364E1B292A9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
rchase1101
Occasional Visitor

I am doing an XY scatter graph that shows data for a span of 20 years.  However, when the graph is made, the x-axis timeline goes all the way back to 1900.  How do you adjust the timeline to only focus on my selected time frame?

1 Reply

@rchase1101 

The easiest fix might be to try a line chart rather than a scatter chart. Line charts understand dates and times.

 

If you still want to use a scatter chart, then you need to change the X-axis minimum scale to a reasonable value.

  1. Enter the desired minimum and maximum dates in two blank cells
  2. Format those cells with Number format and no decimal places
  3. Rightclick the X-axis on your chart, then choose Format axis from the resulting popup
  4. Go to the Text tab in the resulting task pane by clicking the green column chart icon
  5. You will be entering the numbers from step 2 in the Minimum and Maximum scale fields. These appear to have been renamed Minimum and Maximum Bounds in my Office Insider copy of Excel 2016/Office 365.
  6. You may also want to change the Major Units to 30.5 to display your dates along the axis in roughly one month increments.

image.png

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies