Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
John Broderick
 
Posts: n/a
Default Excel equivalent of Matlab stem plot

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


  #2   Report Post  
Tushar Mehta
 
Posts: n/a
Default

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

In article ,
says...
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a 3-dimensional plot in Excel? John W. Mordosky Charts and Charting in Excel 6 April 3rd 23 06:58 PM
How do I plot data on a map in excel Byron Charts and Charting in Excel 3 January 19th 05 08:01 PM
Can you do a Stem and Leaf Plot in Excel Mike Charts and Charting in Excel 1 January 11th 05 12:11 PM
how do I plot mean and standard deviation in excel amg Charts and Charting in Excel 3 January 6th 05 03:53 AM
How do I plot data in Excel that is captured on separate sheets; . krwegner Excel Discussion (Misc queries) 0 November 30th 04 05:43 PM


All times are GMT +1. The time now is 06:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"