DPlot Forum Index DPlot
http://www.dplot.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

VBA Refline

 
Post new topic   Reply to topic    DPlot Forum Index -> Excel
View previous topic :: View next topic  
Author Message
rholt



Joined: 06 Jul 2014
Posts: 4

PostPosted: Sun Jul 06, 2014 10:51 pm    Post subject: VBA Refline Reply with quote

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:

Arrow 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
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2290
Location: Vicksburg, Mississippi

PostPosted: Mon Jul 07, 2014 8:13 am    Post subject: Reply with quote

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.
_________________
David Hyde
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    DPlot Forum Index -> Excel All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
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