Share via

excel scatter plot

Anonymous
2020-11-21T20:35:40+00:00

So I am doing time series analysis. But the date on x-axis aren't the one I have in my column. What do i do to get the correct dates? I have attached a pic.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2020-11-21T20:43:22+00:00

    The X-axis of an XY Scatter chart is always numeric; you cannot get it to display only the dates in your source data.

    If you want that, change the chart type to a line chart with markers only, no lines.

    Double-click the X-axis and specify that it is a Text Axis.

    0 comments
  2. Anonymous
    2020-11-21T20:46:30+00:00

    I don't only want it to display dates. I want it to display the correct date from the source data. If you see my date starts from 3/31/2010 but the dates displayed on the chart are from 7/6/2009.

    0 comments
  3. HansV 462.4K Reputation points MVP Volunteer Moderator
    2020-11-21T21:39:28+00:00

    You can double-click the X-axis and set the minimum and maximum to the appropriate dates (expressed as a number)

    0 comments
  4. Anonymous
    2020-11-25T09:23:25+00:00

    Hi DKFU,

    May I know If you have resolved your problem?

    Please post back if problem persist, we will try our best to help you!

    Regards 

    Jason

    0 comments