Share via

Line Graph Data Table Not Showing Correct Order of Data

Anonymous
2018-07-05T16:08:11+00:00

I have created a line graph that is simple and what I need to show. I would like to add the data table to give actual numbers, but Excel has flopped the data end for end with my months. As you can see below, the January data is showing for July, February data showing in June, etc. The line graph itself is correct, just trying to figure out how to get the data table to show correctly.

Any ideas?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2018-07-05T20:29:41+00:00

    Hi Jay,

    Thanks for sharing with us the file.

    The behavior seems to be related to the value and format of column A. I changed the format of to General and manually input those months. Create a new chart in it. Please check the copy file in the private message.

    Regards,

    Tim

    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-07-05T22:33:02+00:00

    Hi Jay,

    Thanks for your updates. If you have other questions about Office 365, please feel free to post new threads in our forum. Our engineers will give you dedicated support in the new thread.

    Regards,

    Tim

    0 comments