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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks