How to put lines on a column chart

rdionne · Feb 22nd, 2002, 02:44 PM

I am using a column chart to display my histogram data. I need to put some vertical lines ontop of the chart to show data limits.
I tried doing this with a combination line-column chart, but I couldn't figure out how to add the vertical lines. I also tried adding a line shape object, but I don't know how to place the line at the right places.
ActiveChart.Shapes.AddLine takes it's arguments in points and the x axis range changes from chart to chart. Help please.

rdionne · Feb 22nd, 2002, 04:04 PM

I figured it out. Say my data series goes from 20 to 80, plotarea.width=400, and I
want to place a line at 35.
Placement I want =
20 + ((35 - 20)/(80-20))*(400)= 120
Would it be better to do a combination chart than adding the shapes? I don't know how to do the combo chart.
RD

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 02:44 PM	#1
rdionne New Member Join Date: Feb 2002 Location: Texas Instruments Posts: 47	I am using a column chart to display my histogram data. I need to put some vertical lines ontop of the chart to show data limits. I tried doing this with a combination line-column chart, but I couldn't figure out how to add the vertical lines. I also tried adding a line shape object, but I don't know how to place the line at the right places. ActiveChart.Shapes.AddLine takes it's arguments in points and the x axis range changes from chart to chart. Help please.

Feb 22nd, 2002, 04:04 PM	#2
rdionne New Member Join Date: Feb 2002 Location: Texas Instruments Posts: 47	I figured it out. Say my data series goes from 20 to 80, plotarea.width=400, and I want to place a line at 35. Placement I want = 20 + ((35 - 20)/(80-20))*(400)= 120 Would it be better to do a combination chart than adding the shapes? I don't know how to do the combo chart. RD