Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
How do I plot data on a map in excel | Charts and Charting in Excel | |||
Can you do a Stem and Leaf Plot in Excel | Charts and Charting in Excel | |||
how do I plot mean and standard deviation in excel | Charts and Charting in Excel | |||
How do I plot data in Excel that is captured on separate sheets; . | Excel Discussion (Misc queries) |