Share via

Data Table in Chart not showing all data

Anonymous
2020-03-11T14:08:14+00:00

I have a chart using the above table, but the table in the chart does not show the heading of the last column.

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
    2020-03-11T22:16:03+00:00

    Hi Edoardo,

    Thank you for posting your concern here in Microsoft Community! I hope you're having a great day despite the trouble you're experiencing with Excel Chart. We tried replicating the issue here and we've experience the same behavior. When we removed the Mar-19 item under Select Data, the Feb-20 data disappeared. See screenshot below:

    However, when you include the Mar-19 data, the Feb-20 data will appear on the Data table. You may try it by right-clicking the Data table, and go to Select Data.

    Also, we will forward this case to our Internal Support team for further investigation and to get this addressed as soon as possible. We’ll let you know once we reach a resolution. Please standby.

    Regards.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-03-12T09:23:21+00:00

    Thanks a million.

    I'll make work this way for the moment.

    0 comments
  2. Anonymous
    2020-03-12T18:20:54+00:00

    You're most welcome! Should you like to continue troubleshooting this case, we would like to request a sample file so we can further determine what is causing the issue. You may share it with us by creating a OneDrive link and forward it via Private Message.

    Regards.

    1 person found this answer helpful.
    0 comments