Jul 02 2021 06:43 PM
Hi everyone!
1. Device and OS Platform: Mac/macOS Big Sur version 11.4
2. Excel product name and version number: Office 365 and 16.50(21061301)
3. Question:
I want the x-axis of the chart reflects exactly the same of what I have in the table. Each row has different value. Hence, I would expect a long x-axis.
However, it is not reflecting what I needed right now. I have attached the excel file in this post.
Is there any kind soul could assist me, pls?
Thank you.
Jul 03 2021 03:09 AM
@Roger1981 Not sure how your chart was created, but the data ranges seem to have been set wrong. Or I just don't understand what you are trying to do. Created a new chart with what I believe is what you need, though I did not format it to look like yours. Compare the data setting and see if mine work for your purpose.
Jul 03 2021 03:53 AM
SolutionYou use scatter chart which doesn't work with text X-axis. However, in your case simple line chart gives the same plus correctly shows X-axis.
Jul 10 2021 06:01 PM
Jul 10 2021 06:01 PM
Jul 03 2021 03:53 AM
SolutionYou use scatter chart which doesn't work with text X-axis. However, in your case simple line chart gives the same plus correctly shows X-axis.