add vertical line to floating bar chart

  • Thread starter Thread starter bbxrider
  • Start date Start date
B

bbxrider

my chart has floating horizontal bars
they are price ranges that all have the same center point
i'm trying to draw a vertical line, starting from the x axis, going up thru
all the floating bars
i can set up a series on sheet with with the center point based on sheet
data, no problem there
the examples from google and the peltiertech samples all seem to add the
vert line
as part of a scatter chart,
either i'm missing something simple, or maybe this not possible, ie, the
chart has to a line/scatter chart to begin with??
 
Hi bbxrider,

You should be able to add a new data series and then change the chart
type of it to xy scatter. Then use the Data Source dialog to change the
x-y values.

If you haven't already take a look at my examples, it contains various
techniques for putting lines on various chart styles.
(http://www.andypope.info/charts/averageline.htm)
my chart has floating horizontal bars
they are price ranges that all have the same center point
i'm trying to draw a vertical line, starting from the x axis, going up thru
all the floating bars
i can set up a series on sheet with with the center point based on sheet
data, no problem there
the examples from google and the peltiertech samples all seem to add the
vert line
as part of a scatter chart,
either i'm missing something simple, or maybe this not possible, ie, the
chart has to a line/scatter chart to begin with??
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top