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.
- nvaudDec 21, 2022Copper ContributorPerfect! Thank you so much!