Forum Discussion
NVITCA
Dec 15, 2022Copper Contributor
Combo chart with 2 variables (4 columns) and 2 groups
I can't find the answer by googling, someone can help... I have a data set with two variables (year and duration). Within duration, there are 3 columns (ever, 6+months, 12+months). I'd like to ha...
HansVogelaar
Dec 15, 2022MVP
Use the data layout as in your post.
Create a clustered column chart based on the data.
Activate the Chart Design tab of the ribbon
If the x-axis labels are Ever, 6+ months etc., click Switch Row/Column.
Next, click Change Chart Type.
Select Combo Chart.
With a bit of luck, Excel will change the ITCA series to Line Chart. If not, select each of those series and select Line.
Click OK.
nvaud
Dec 21, 2022Copper Contributor
Perfect! Thank you so much!