custom line drawing in owc line charts

Similar Threads:

1.Problem with custom line chart, lines with two axes

I created a custom line chart with lines on 2 axes.   It was supposed to 
show date by months in the x axis, number of records in the first y axis, 
and percentage of records in the second y axis.   It does show the x and y 
axes correctly.

I selected month, and then the three adjacent columns of data to plot in 
three separate lines on this plot; number of acceptable records, % of 
acceptable records to total, and % of acceptable records to valid.

My legend shows number of acceptable records, % of acceptable records to 
total, and % of acceptable records to valid.

The chart graphed all acceptable records and % of acceptable records to 
valid (the first and third of the three adjacent columns I selected 
together) correctly, but graphed % of acceptable records to total (the 
second of the three adjacent columns selected together) as a flat line with 
y value of 0.

I actually made two of this graph; one for fiscal year 2004, and the other 
for fiscal year 2005, with identical results.

My boss suggested that maybe the names are two similar and had me change 
one, and this changed nothing.

% acceptable records to total ranges from 20 to 32 percent, and % of 
acceptable records to valid records ranges from 19 to 39 percent, and when 
these two are graphed together on a line graph, they show jagged lines that 
for the most part run parallel to each other.   The data itself does not 
present a logical reason why one column of data should flatline at zero on 
the graph.

What is the reason why only two of the lines graph correctly on the custom 
line chart with two axes?  Is it supposed to display correctly only two 
lines?   And why did it pick the first and third column of data instead of 
the first and second line of data to display correctly?

Is tehre a way to get all three columns of data to graph correctly?

-- 
Yours,
Dora Smith
Austin, TX
 XXXX@XXXXX.COM  

2.Custom Line Width in Line or Scatter Chart

Is there any way to create lines of a custom width in a line or scatter 
chart?  I occasionally have a need for a very thick line, thicher than the 
maximum that the dialog allows?

Thanks.

3.How to draw a line on a chart, and have it move with the chart

4.Line Draw VERY Slow (lots of lines)

Hi,
I have an application that builds a grid map and draws lots of lines between 
cells.
The number of lines is currently over 600 but could grow more and each line 
contains a hyperlink and screentip text.

The app works reasonably fast for the first 3-400 lines but exponentially 
slows to a crawl.  By the end it could be a line per second or slower.

I've seen recommendations not to use the "selection."  command but I can't 
figure out how to use it for my application.

Below is the code that works.
If I try to use LineShape.Hyperlinks.... I get an error.
I've also noticed that excel shows each line plotting even though I have 
sreenupdating off.... am I missing something on that?

Thanks, MikeZz

Set LineShape = ActiveSheet.Shapes.AddLine(x1, y1, x2, y2)
LineShape.Select

ActiveSheet.Hyperlinks.Add Anchor:=Selection.ShapeRange.Item(lineName), _ 
Address:= "", SubAddress:=linkAdd, ScreenTip:=screenTipText

5.How to draw a line every 5 lines

You can use a simple IF statement to see if the CountThem 
is evenly divisible by 5

If Me!CountThem / 5 = Me!CountThem \ 5 Then
    Me.Line54.Visible = -1
Else
    Me.Line54.Visible = 0
End If

The "/" performs standard division. The "\" operator 
returns only the whole number portion of the result (no 
remainder, or decimals). 

>-----Original Message-----
>I have the following code for drawing lines every 5 
lines.  It worked for
>something that was, at most, 14 lines.  Now I want to do 
it for something that
>could have 200 lines.  So I now need better code.  How do 
I correct that first
>line below?  "Counthem" is the name of my running sum 
textbox.  "Line54" is the
>name of the line.
>___________
>
>If Me!CountThem = 5 Or Me!CountThem = 10 Then
>   Me.Line54.Visible = -1
>Else
>    Me.Line54.Visible = 0
>End If
>___________
>
>I thought this was in my book.  But I can't find it.
>
>Thanks,
>
>Matt
>.
>

6. Using the Line Method to Draw Horizontal Lines

7. line method draws line in different position in 2003 vs 2007

8. line method draws line in different position in Access 2003 vs 200