View previous topic :: View next topic |
Author |
Message |
rholt
Joined: 06 Jul 2014 Posts: 4
|
Posted: Sun Jul 06, 2014 10:51 pm Post subject: VBA Refline |
|
|
Afternoon,
I'm having some issues with the refline command in VBA.
Could someone please explain the standard means to define colours other than black. I require red (255,0,0) and Light Grey (192,192,192)
I need to output the following:
Refline(15,5,???,10,-100,"300m curve")
Parameters:
1: draws line on secondary Y2 with label
2: 5 (medium dash)
3: need to specify red and light grey as explained
4: 10 is the line width in 1000ths of inches
5: value
6: legend entry for the reference line. Use "" if you don't want an entry in the legend. |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2311 Location: Vicksburg, Mississippi
|
Posted: Mon Jul 07, 2014 8:13 am Post subject: |
|
|
The color values are red component + blue*256 + green*65536. That's a mess to do in your head, but they can be expressed in hexadecimal with a "0x" prefix, which makes it a bit easier. Red=255 can be expressed as 255 or 0xff (not case specific) or 0x0000ff. Your light grey can be expressed as 12632256 (192+(192*256)+(192*65536)) or 0xC0C0C0. _________________ Visualize Your Data
support@dplot.com |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|