Apr 24 2021 08:51 PM
This I'm sure is super simple, and I feel super stupid. I'm attempting to create a simple chart in Excel from just 5 sets of data (Excel file attached). I want it to look like this, just updated. I am having a heckuva time getting the chart to work. Come on, what's the secret?
Apr 24 2021 09:54 PM
Solution@Ted_W1855 No real secrets, but the last four numbers in your list are texts. How did you enter them? Just retype them and it will work as desired.
Apr 25 2021 01:59 PM
@Riny_van_EekelenDuh! Too easy. Now I feel really stupid. Thanks for your prompt reply.
Sep 25 2021 05:07 PM
Sep 25 2021 10:27 PM
@AlohaBill77 Not really similar, so it would have been better to open a new thread fro your question.
Right-click on the horizontal axis and choose to format it. Then you should see an option that sets the major units to 1 month. You can change it to 1 day, or 7 days, if you so desire. But it could clutter the axis, especially if you have many data points or if you are covering a long period.
Example (screenshots taken on a Mac, but it's similar on a PC)
From:
To:
Apr 24 2021 09:54 PM
Solution@Ted_W1855 No real secrets, but the last four numbers in your list are texts. How did you enter them? Just retype them and it will work as desired.