Share via

Excel 2016 - Plot legend entry disappears in Select Data Source after clicking cancel

Anonymous
2017-08-11T13:46:20+00:00

I noticed a potentially a malfunctioning feature in Excel the second legend entry is added but cancelled before accepting in Select Data Source dialog, also the first already accepted series is disappeared.

It is shown more detailed in a video: https://youtu.be/P0BWjP1mRI8.

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-08-12T17:42:07+00:00

    Thanks Anna Bon for your reply.

    • It was noticed some times ago and it is reproducible with the same Excel version.
    • No special changes.
    • No
    • No special troubleshooting is being done. The error is easy to go round.

    Excel version were this error was found is 16.0.6701.1041 32-bit.

    Error is not found in later version, e.g. 16.0.8229.2086 32-bit.

    Maybe it is best to ask IT department to update office.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-08-11T22:22:05+00:00

    Hello,

    For us to determine the main cause of this issue, we just need to confirm some information. Please answer the following:

    • When did you first encounter this issue?
    • Any changes that took place in your computer before this issue occurred?
    • Have you created PivotTable in Excel?
    • What troubleshooting steps have you done so far?

    Was this answer helpful?

    0 comments