Need help using both Bar Graph and XY scatter

[jbondsr]

Hello.
I need some help figuring how to accomplish this task:

I have two sets of y-axis values that are under the same set of x-axis
value. I am using one set of y-axis values as a bar graph, and the
other as an XY scatter. The problem is that the dots from the XY
scatter appear on top of the bars from the bar graph. Is there anyway
to make the dots move next to the bars instead of on top of them, and
without making another set of the same x-axis values? (Like how to bar
graphs show up next to each other under the same x-axis value, except
that I want one to be a bar and the other a dot.

 

[Jon Peltier]

You can use the same axis, but you'll have to adjust the precise X data
of the series. Something like this, perhaps:

http://peltiertech.com/Excel/Charts/ClusterColAndLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______