I am trying to create a combo scatter and stacked column graph. The X axis should appear with the Age as in the scatter graph shown, but the combo graph is showing an item counter of all the items in my data set instead. How do I get the age bands to appear in my combo graph instead of the counter items 1-20? I want to use the stacked column chart "behind" the scatter. Thank you!
Combo Graph.xlsx | |||
---|---|---|---|
L | |||
24 | |||
Sheet1 |