software

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: www.excelforum.com/member.php...oamp;userid=15133
View this thread: www.excelforum.com/showthread...hreadid=543289A quot;linequot; 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:

peltiertech.com/Excel/Charts/BarLineCombo.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;londonalquot; gt; wrote in
message ...
gt;
gt; hi, i have created a BAR chart(horizontal) and have two series of data
gt; with two axis at top and bottom. I would like on of the data series not
gt; to be represented with a bar but with a point, like on a scatter graph.
gt; Is this possible, and if so, please could you let me know asap how to do
gt; this. Important bit of work being carried out. Thank you so much for
gt; your time.
gt;
gt;
gt; --
gt; londonal
gt; ------------------------------------------------------------------------
gt; londonal's Profile:
gt; www.excelforum.com/member.php...oamp;userid=15133
gt; View this thread: www.excelforum.com/showthread...hreadid=543289
gt;