Aug 08 2023 07:02 AM
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 the X axis ends before the second Y axis crosses it. I cannot figure out how to fix this.
Aug 08 2023 08:28 AM
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?
Aug 08 2023 08:54 AM
Aug 08 2023 09:05 AM
Aug 08 2023 02:41 PM
SolutionThanks. 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.
Aug 09 2023 07:12 AM
Aug 08 2023 02:41 PM
SolutionThanks. 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.