Forum Discussion

Lydi4's avatar
Lydi4
Copper Contributor
Aug 08, 2023
Solved

Excel chart with 2 Y axes second Y axis will not align with maximum value of X axis

Hello,   I cannot get the second Y axis of my chart to line up with the maximum value on the X axis and I need help. The chart resembles this: As you can see, there is a blank space after th...
Charting
excel
  • HansVogelaar's avatar
    HansVogelaar
    Aug 08, 2023

    Lydi4 

    Thanks. The series # 1 FF Ave and #2 FF Ave are plotted as XY Scatter Charts. The x-axis of a scatter chart is strictly numeric - in this case it includes all numbers from 0 to 28, without skipping the unused numbers.

    In the attached version I have changed them to Line Charts with no lines but with visible markers.

HansVogelaar's avatar
HansVogelaar
MVP
Aug 08, 2023

Lydi4 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

  • Lydi4's avatar
    Lydi4
    Copper Contributor
    Aug 08, 2023
    Sure, let me give it a shot
    • Lydi4's avatar
      Lydi4
      Copper Contributor
      Aug 08, 2023
      I cannot attach anything but here's a google drive link, not sure if this will work: https://docs.google.com/spreadsheets/d/1lfpXfc2vu2gTJvP_ToCMfPpTxK3AGfft/edit?usp=sharing&ouid=116217340169138485718&rtpof=true&sd=true
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Aug 08, 2023

        Lydi4 

        Thanks. The series # 1 FF Ave and #2 FF Ave are plotted as XY Scatter Charts. The x-axis of a scatter chart is strictly numeric - in this case it includes all numbers from 0 to 28, without skipping the unused numbers.

        In the attached version I have changed them to Line Charts with no lines but with visible markers.

Resources