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.

  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


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

Multiple charts query.

Discussion in 'Discuss Data Visualizations and Charting' started by vaidmohammed, Apr 3, 2018.

  1. vaidmohammed

    vaidmohammed New Member

    I need your experts help to generate a combo chart in Excel. Below are the details, please help me with your expert advises.

    Attached is my data.
    Column A = Client Names
    Column B - D = No. of Production defects found in last 3 months.
    Column E - G = No. of UAT defects found in last 3 months.
    Column H = No. of defects closed in last month.

    I need to prepare a single chart which shows all the above values.

    Looking for a 3 axis chart:
    X Axis = Column A values i.e. Client Names should be shown.
    Y Axis = Count of Production and UAT defects should be shown.
    Z Axis = Count of Defects closed should be shown.

    Column B-D should be shown in Stacked Column chart.
    Column E-G should be shown in another Stacked Column chart, in the same plot area.
    Column H should be shown in Line with Markers chart, in the same plot area.

    Attached Files:

  2. GraH - Guido

    GraH - Guido Well-Known Member

    Dillina likes this.

Share This Page