Line chart misunderstanding columns
I am trying to create a line chart based on the data in screenshot 1.
However, it's appearing as per the line chart in screenshot 2.
I've tried changing the Category of the cells containing the years to Custom > YYYY (stab in the dark) but they all default to 1905.
Any ideas how I can solve this?
What do you want it to look like?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I can only see one screen shot not two. Please clarify
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
The years are not proper dates. Try this:
1. Change 2014 in A2 to 01/01/2014.
2. In A3, type =EDATE(A2,12) and enter.
3. Copy the formula down.
4. With column A selected, change the formatting to custom - yyyy.
Does your chart now work as you want it to?
Last edited by AliGW; 12-31-2018 at 05:21 AM.
Re: Line chart misunderstanding columns
There are definitely two screenshots attached to the first post.Originally Posted by Richard Buttrey
Yes! Thank you!: )
Last edited by AliGW; 12-31-2018 at 05:35 AM.
Lovely!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
My mistake. I thought the table and chart were a single picture of a range in Excel and alongside a chart.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks