Dec 15 2022 07:15 AM
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 have data for two organizations on the same graph - one as a bar and one as a line for reference. I've tried setting-up my chart a couple different ways but can't get it to show-up how I need it to when I click on the "combo" chart type. Below is what I see when I"feels" like should be right.
Any advice you have for changing my chart set-up or selecting different variables in combo would be much appreciated!
Ever | 6+ months | 12+ months | ITCA Ever | ITCA 6+months | ITCA 12+months | |
2018 | ||||||
2019 | ||||||
2020 | ||||||
2021 |
Dec 15 2022 12:49 PM
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.
Dec 21 2022 08:28 AM