Forum Discussion
Roger1981
Jul 02, 2021Copper Contributor
How do I reflect the x-axis exactly the same to the table?
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 ch...
- Jul 03, 2021
You 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.
Riny_van_Eekelen
Jul 03, 2021Platinum Contributor
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.
- Roger1981Jul 10, 2021Copper ContributorThank you. It’s solved