Want to see all the map text in small provinces

Jonathan Brotto 1,076 Reputation points
2022-02-14T21:27:22.307+00:00

I am making a sales report but can't see the map details to the Atlantic provinces. Is there a way around this? Could I expand the text box or make them float?

174205-image.png

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

Accepted answer
  1. Ceasar Chen_MSFT 4,481 Reputation points
    2022-02-24T09:11:34.867+00:00

    Hi, @Jonathan Brotto
    To place a text label for each province, you can click Map Labels in the upper toolbar to add the captured image to the spreadsheet.
    In order to add the captured image to the spreadsheet, you can click on the new scene in the toolbar, select the custom scene, and add the image, as shown:
    177418-image.png


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Ceasar Chen_MSFT 4,481 Reputation points
    2022-02-15T08:52:35.017+00:00

    Hi, @Jonathan Brotto
    Do you want the data to be displayed where the red circle is on the data map?
    174405-image.png
    If this is the case, it is recommended that you enter more detailed geographic information in the form, such as: country, province/state, city, Example screenshots are as follows:
    174406-image.png
    Because Excel may not be able to identify these areas as shown on the city map, some areas have the same or similar names in different countries. For details, you can refer to this link:Frequently Asked Questions


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.