Referencing the lines in a graph

  • Thread starter Thread starter Laurel
  • Start date Start date
L

Laurel

Could someone give me the syntax for referencing a line on a graph in VB?
I'm actually working in Access, not Excel, but was advised that this group
knew lots about graphs. If someone is also familiar with Access and could
give me the whole reference, that would be icing on the cake. My intent is
to make the lines visible/invisible depending on what buttons are checked by
the user. The chart is directly on the form, not on a sub-form.
 
Laurel -

From VBA, you change the line type of an Excel chart using these:

' hide the line
ActiveChart.SeriesCollection(1).Border.LineStyle = -4142 ' xlnone

' restore the automatic line
ActiveChart.SeriesCollection(1).Border.LineStyle = -4105 ' xlautomatic

Once you start throwing Access forms around, and using MSGraph instead
of Excel for the charts, I'm less confident in my ability to provide
meaningful syntax.

- Jon
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

parameter the axis of a graph 1
Graph Line Width ? 1
Dynamic Graphs - code needed? 1
Microsoft office2010 trend lines 1
Graphing 2
Combining a 2-D column graph and a 2-D line graph on the same char 3
Graph on a form 1
Macro to graph (or draw) a vertical line on the chart 7

Back
Top