Excel equivalent of Matlab stem plot

[John Broderick]

I would lik to plot a sequence of data points as vertical lines topped with
either nothing, a circle, a dot or an arrow head.
This is done with the stem function in Matlab, but it is in no way related
to a stem-and-leaf plot.
It is used to plot discrete-time signals or a frequency domain discrete
spectrum.

Assuming this is possible, how can I combine this with a standard column
chart?

Thanks,
John

 

[Tushar Mehta]

You could use a Line or XY Scatter chart for the non-column series.
Format this series to have 100% negative error bars. For each
individual point, format the marker as nothing or a circle of an
appropriate size. For the arrow-head consider a marker shape other
than a circle. Alternatively, create the arrow-head as a graphic
image, copy it, select the marker you want customized (select the
series, pause, then select the marker) and paste.

And, if this is a lot of work for something that MatLab does easily,
well, XL is not Matlab. ;-)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions