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

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/
_______


"londonal" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> londonal
> ------------------------------------------------------------------------
> londonal's Profile:
> http://www.excelforum.com/member.php...o&userid=15133
> View this thread: http://www.excelforum.com/showthread...hreadid=543289
>