How to create a xy stick diagram?
 

I want to create a xy diagram with verical sticks (lines), where the stick
position is defined by the x-values, the stick lengh by the y-values.
(context: mass spectrometry).
There is no such standard chart type - at least I could not find it.

How to create a xy stick diagram?
 

Hi

Create a xy scatter, markers only.
Add negative custom Y error bars to the data series using your Y values
as the data for your error bars.

Jon Peltier's wab on error bars should help.
http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

Cheers
Andy

heinrich wrote:
I want to create a xy diagram with verical sticks (lines), where the stick
position is defined by the x-values, the stick lengh by the y-values.
(context: mass spectrometry).
There is no such standard chart type - at least I could not find it.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info