"Chart Data Range" gets blanked out in "Select data" ; data range also not highlighted when whole graph is selected

Anonymous
2023-03-06T12:30:31+00:00

I need to understand in what situations the "Chart Data Range" gets blanked out in the "select data source" of an existing graph with data on same sheet. I need to check the data range at multiple review times . As a work around, I selected the whole graph too to see the data range highlighted but this doesn't work either: data is on the same sheet (Have seen this problem many times).

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 No comments
{count} votes

7 answers

Sort by: Most helpful
  1. Anonymous
    2023-03-07T08:11:35+00:00

    yeah sure, thanks AnnaThomasH

    0 comments No comments
  2. Anonymous
    2023-03-07T08:15:50+00:00

    You are welcome

    0 comments No comments