Here's an example of how you could use facet_grid
to include all 4 variables on the same plot.
Note that I generate some dummy data, since I had trouble importing your dataset into R
.
generate data
library(ggplot2)
theme_set(theme_bw())
set.seed(123)
df1 <- data.frame(s1 = sample(letters[1:3], 11, replace = T),
s2 = sample(letters[4:6], 11, replace = T),
s3 = sample(letters[7:9], 11, replace = T),
s4 = sample(letters[10:12], 11, replace = T),
stringsAsFactors = FALSE)
edit:
Maybe this is closer to what you're after:
ggplot(df1)+
geom_bar(aes(x = s1), position = 'stack')+
geom_bar(aes(x = s2), position = 'stack')+
geom_bar(aes(x = s3), position = 'stack')+
facet_wrap(~ s4)
If you proceed in this manner, you should definitely note that the values on the x-axis come from three different variables.
IMHO: While I'm no expert on the subject, I do think it's a bit dubious to create a visualization with three different variables on the same axis, and ggplot2
gives you plenty of options to avoid proceeding in such a manner.
make plot using facet_grid
ggplot(df1, aes(x = s1, fill = s2))+
geom_bar(position = 'stack')+
facet_grid(s3~s4)
make plot using interaction
and facet_wrap
Now, suppose you don't want the two grouping factors as facets, and just prefer one facet. Then, we can use the interaction
function.
ggplot(df1, aes(x = s1, fill = interaction(s2,s3)))+
geom_bar(position = 'stack')+
facet_wrap(~s4)
use Rmisc::multiplot
Finally, we can create three separate plots, and then use Rmisc::multiplot
to plot on the same page.
library(Rmisc)
p1 <- ggplot(df1, aes(x = s1, fill = s2))+
geom_bar(position = 'stack')
p2 <- ggplot(df1, aes(x = s1, fill = s3))+
geom_bar(position = 'stack')
p3 <- ggplot(df1, aes(x = s1, fill = s4))+
geom_bar(position = 'stack')
multiplot(p1,p2,p3, cols = 3)
Best Answer
I think you are talking about an addin. Addins written in VB6 for VB6 use a reference to Microsoft Visual Basic 6.0 Extensibility. You compile the application as an ActiveX EXE and as such it can be placed anywhere on the hard drive. You can look at vbaddin.ini for the *addin.*Connect setting where addin will be the addin name. Unfortunately this is not the file name or path, but it should be close enough to help you search the the application.