1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Target vs Achievement Chart

Discussion in 'Ask an Excel Question' started by ushaanu, Jul 12, 2018.

  1. ushaanu

    ushaanu Member

    Messages:
    186
    Dear All,

    I have some data in excel with agent monthly Achievement and target sheet .
    in data sheet monthly target remain same , I need target vs Achievement chart. problem is that target mention only one cell as it is same for the whole year .

    sample file enclosed .

    thanks
    Anu

    Attached Files:

  2. Eloise T

    Eloise T Active Member

    Messages:
    790
    Were you looking for something like this? See attachment.

    upload_2018-7-12_2-39-48.png

    Attached Files:

  3. p45cal

    p45cal Well-Known Member

    Messages:
    1,215
    Another take, similar to Eloise T's, but showing the target as a line:
    upload_2018-7-12_19-57-44.png
    Also, selecting more than one name brings up a stacked chart, with the collective target showing:
    upload_2018-7-12_19-58-26.png

    Attached Files:

    Eloise T and Thomas Kuriakose like this.

Share This Page