Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Odd chart type needed
I need a chart type that does not seem to be available in Excel 2007
or 2003. I'm graphing a gamma ray emission spectrum. The x-axis is photon energy. The y-axis is number of gamma rays per second The plot requires vertical LINES at the energy of each gamma ray. The height of the line is the number of gamma rays. The x position of each line is its energy. The chart COULD be a vertical bar chart with very narrow bars. But Excel won't allow bars that thin, and needs them equally spaced. Is there a way to create such a vertical line plot in Excel 2007 (or 2003)? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Odd chart type needed
On Apr 13, 12:30*pm, Neal Carron wrote:
I need a chart type that does not seem to be available in Excel 2007 or 2003. I'm graphing a gamma ray emission spectrum. The x-axis is photon energy. The y-axis is number of gamma rays per second The plot requires vertical LINES at the energy of each gamma ray. The height of the line is the number of gamma rays. The x position of each line is its energy. The chart COULD be a vertical bar chart with very narrow bars. But Excel won't allow bars that thin, and needs them equally spaced. Is there a way to create such a vertical line plot in Excel 2007 (or 2003)? One way is to plot the numbers as points using a xy scatter graph, and then putting in negative error bars that are the same size as the number so they reach right down to the X axis. Use custom error bars when you get to that point. 2003 was easy. 2007 have "updated" the method to make it, typically, more difficult. Cheers xt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic chart- curve dropping to zero ( chart type- Line) | Charts and Charting in Excel | |||
Combine a Bubble chart with other chart type | Charts and Charting in Excel | |||
Pivot Chart - default chart type | Excel Discussion (Misc queries) | |||
Pivot Chart: cannot apply the default chart type... | Charts and Charting in Excel | |||
Adding a line Chart Type to a stacked-clustered Chart Type | Charts and Charting in Excel |