custom line drawing in owc line charts

Microsoft OFFICE


  • 1. Create office objects on server
    Not sure if this is the most appropriate group - feel free to redirect me. If I have a web application that needs to programatically create and manipulate office documents (word & excel), what options do I have other than installing MS Office on the web server? Can I just install an Office SDK or a version of Office that has no user interface? tia
  • 2. OWC being blocked by McAfee HIPs
    we're using OWC 11 and IE 6 on windows xp. Have asp code that queries a sql database then produces either a csv, htm or xml file on our web server. That server/path/filename is then passed to OWC 11 'Spread' control which renders the data in a spreadsheet inside of IE. This has been working fine until recently when company deployed McAfee HIPs. Now, the spreadsheet control opens in IE just fine, but is completely empty. If we 'disable' IPS in HIPs, the data displays just fine. Error message in HIPs log is: " Attack type: IE SourceURL NULL Dereference Vulnerability " Any ideas on what to add to to code to eliminate this error ??? ( company will not remove iexplore.exe from HIPs monintoring ). Thanks.
  • 3. OWC 10 & 11 Export Behavior
    Hi, We have reports that used OWC 9 and have been changing them to use Version 10 (or 11). Version 9 of OWC, when exporting would open the Work book in an already open Excel instance. So if we ran 3 reports, and exported each one individually, they would all open on the same excel instance. Users could then copy worksheets between work books. With version 10 and greater, when you export, it opens up a new instance of Excel. So if you export 3 reports, you get 3 instances. Excel does not permit copying Work books, Formulas, etc between instances. Is there anyway we can program around this behavior and have it all open in the same instance, just like OWC 9 would do? Thanks

custom line drawing in owc line charts

Postby Thao Moua [ms] » Sat, 08 Nov 2003 06:43:24 GMT

There is no way to access the markers.  If you just want 
to hide the marker then you can always switch the series' 
Type back and forth between chChartTypeLine and 
chChartTypeLineMarkers.  This will add/remove the markers 
but keep the series segment formattins.

Thao Moua
OWC Webchart Support

This posting is provided "AS IS" with no warranties, and 
confers no rights. Use of included script samples are 
subject to the terms specified at 

chart of the type
segments and also
have data
programming is in VBScript
can i only
setting the
find more info,

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?

Dora Smith
Austin, TX

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?


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

4.Line Draw VERY Slow (lots of lines)

I have an application that builds a grid map and draws lots of lines between 
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)

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
    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
>    Me.Line54.Visible = 0
>End If
>I thought this was in my book.  But I can't find it.

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

Return to Microsoft OFFICE


Who is online

Users browsing this forum: No registered users and 91 guest