vaidmohammed
Member
Hi,
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.
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.
