Share via

Moving Target Chart

Anonymous
2022-10-23T05:32:07+00:00

Dearest Wizards,

A11-A60 has U.S. State names but is not 'always' complete. I have used the UNIQUE function to keep them all toward the top of the column.

B11-B60 has graphable data for each of those states.

I want to be able to make a clean looking chart chart that shows just results from the states that I have data for i.e. without gaps.

How do I do this?

TIA for your assistance,

Sam

Microsoft 365 and Office | Excel | For home | MacOS

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-10-23T14:13:22+00:00

    Dear Sam,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you. 

    Per the description shared, I would like to request you to share the sample data of your workbook and your requirement in the screenshots, so it will help us to better understand and guide you further.

    If possible, please make a copy of the sample workbook and share it with us by uploading it to OneDrive or any cloud location.

    We look forward to your response. Thanks for your cooperation.

    Sincerely,
    Mia | Microsoft Community Moderator

    Was this answer helpful?

    0 comments