Combo Graph Issue with X-Axis

DFNJ

New Member
Joined
Jul 7, 2023
Messages
10
Office Version
  1. 2021
Platform
  1. MacOS
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
 
Well, graphs do not copy wel with xlBB.
Probably critical issue is not visible (this is default setting) secondary horizontal axis. And while you can have the same vertical axis, you need separated (at the end of the day you may show just one, but there has to be activated, second one, just may be not visible. Have a look on my recent post dealing with similar problem: Is it possible to have a floating box showing limits in a scatterplot?
 
Upvote 0
Thank you. I figured out that I was missing data on the X axis on two of my series.
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,919
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top