Share via

How to add a secondary X axis to an Excel scatter plot?

Anonymous
2019-09-03T14:05:43+00:00

Please have a check at the following Excel chart.

I have a problem in plotting (x-y scatter plot) series using 2 horizontal axis, one being a date ("date no") and the other one a calculated person age at that date. Series 1 is on the primary vertical axis while Series 2 is on the secondary vertical axis.

The problem I have is plotting the 2nd horizontal axis ("age") corresponding to the "date no".

I had a similar question in the past but found the solution too complex to implement, There must be a more straightforward solution. Tks.

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
Answer accepted by question author
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2019-09-09T11:02:19+00:00

    Indeed, a dummy series would be the way to do that.

    1 person found this answer helpful.
    0 comments
Answer accepted by question author
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2019-09-08T15:08:58+00:00

    I basically did what I described in my first reply, except that I used this for series 2:

    =SERIES(Sheet1!$A$5,Sheet1!$B$3:$I$3,Sheet1!$B$5:$I$5,2)

    1 person found this answer helpful.
    0 comments

11 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2019-09-09T08:01:03+00:00

    You cannot create a secondary axis if you have only one series. But you can change the x-axis values for the series the same way.

    0 comments
  2. Anonymous
    2019-09-09T08:29:00+00:00

    Ah OK thanks. Then I need to find another way to do that. We (you) solved the issues for 80% of my plots but need to find a way for the remaining 20%. I need to have double H axis, date and age, as for the case with two series, also in the case of a single series. I am thinking maybe to trick a bit the system by creating a separate horizontal line superimposed on the top of the plot, with age marks. Will try to figure something when more time. Any comments welcome. Thank you a lot for your help!

    0 comments