Two axis- is it possible to have one bar and one point?

[londonal]

hi, i have created a BAR chart(horizontal) and have two series of data
with two axis at top and bottom. I would like on of the data series not
to be represented with a bar but with a point, like on a scatter graph.
Is this possible, and if so, please could you let me know asap how to do
this. Important bit of work being carried out. Thank you so much for
your time.

 

[Jon Peltier]

A "line" chart cannot be oriented with its category vertical, that is,
parallel to the bar chart's. However, you can use an XY series type, with
the source data for the X and Y as appropriate to a horizontal X axis, and
using various scaling factors to assure correspondence of the two series.

This example may help:

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

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