add vertical line to floating bar chart, still trying

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

bbxrider

still no luck trying to follow
http://peltiertech.com/Excel/Charts/AddLineVertSeries.html
when i create and paste special the new series, the one that should end up
as the vertical line,
there is no new plot on my chart that is available to be selected to specify
that it be a say a xy scatter chart,
and then after that go ahead and work the secondary axis adjustments etc.
i have 2 series currently on the chart, each one creates 2 floating bars and
the x axis values are set by a macro
so that the bars are floating in a relevant price range, eg if the longest
bar is say 50-60 the x axis ranges from 30 to 80
my chart is a saved custom version of the standard floating bar, which gets
some of desired settings from the start
and the rest like the values on the x axis are set by macros, mostly invoked
from change cell events
and just in general wondering, when you specify a different chart type for a
new plot, is that really overlaying a 2nd chart on the first
or is it simply that each plot can be a different 'style', style being the
chart type
 
When you add the series, it might not be visible, depending on the
values and the axis settings, etc. You can still select it, however.
Select a visible series, then use the up and down arrows to select other
series. Watch in the name box (above the top left visible cell) to see
when the right series is selected.

Chart types can be applied to a chart, so that each series conforms to
the type. Chart types can also be applied to a series, so that the
series conforms to the new type, while other series don't, in a sense
overlaying the original chart with a series of another type. In your
floating bar, you need to just select that elusive series and change its
chart type, while not changing the whole chart's type.

- Jon
 
thanks for the reply again, this is dragging on, that arrowing around is a
great tip to find the data series, but
changing the cells for the series i want to make the vertical line, is
showing up, must have done something wrong b4
but when selecting the bar for the 'vert' series and change that to line
chart, the whole chart changes, even
the axeses are reversed!!!,
what is weird, as i arrow around, i get highlights for series 1, 2, for
those 4 bars, the series 1 is the 'left' side of the bars, from 0-to the
start of the bar, and series 2 is the bars themselves, for series3 it is the
bar itself, and on the same line as the 2nd bar up from the bottom
but series 4, is an 'invisible bar' but not on the same category line as
series 3, it is on the first category line up from the bottom (x axis)
and it is to the right side of where series 3 is, whew, thats kinda hard to
visualize,

am thinking becuase i'm using a custom saved floating bar chart for the
'original' somehow the floating bar or my custom settings
are somehow interfering with the way this normally works
if you see something let me know, otherwise i'm attempting to do the same
thing but forcing a regular bar chart to be floating like and
see if that will work
col1 col2 col3 col4<====category x axis labels
42 41 40 38<====series1
12 14 16 20<====series 2

blank vert
48 0<====series3
48 1<====series4
 
Make sure you change the new series only to an XY Scatter chart type,
not a Line chart type. Also, when you add the new series, you need to
add it with series in columns, which is the opposite orientation as the
floating bar data. This way you get a two-point series, not two
one-point series.

- Jon
 
thanks again for all your continuing help, tried the latest suggestions,
this just doesn't seem to work
series1 in columns, not rows, see http://job1data.com/xcelchart3.htm
after changing ONLY the series1 to a xy scatter, still get same results
whole chart changes to scatter see , http://job1data.com/xcelchart2.htm

i tried a bunch of different cell patterns for the series1 always the same
result

it seems the series2 and series3 are really in column format as well, where
the series2 bars are from 0 to the number in the cells
and series3 bars are from the end of series2 bar for the distance in the
cells
 
Okay, BBX, something funny is going on. If your workbook isn't too big,
send it to me, and I'll have a look.

- Jon
 
Back
Top