[R] how to change the y-axis to logarithmic in a barplot ggplot

[Maria Lathouri]

Dear all, 


I am having the following dataset
fc<-
ID    values    databases
Al    0.15    phreeqc
Al    0.6    carbfix
Al    0.47    actual
Ca    7.2    phreeqc
Ca    7.2    carbfix
Ca    0.3    actual
Na    14.4    phreeqc
Na    84    carbfix
Na    106    actual
Cl    22    phreeqc
Cl    21.9    carbfix
Cl    72.1    actual
Fe    0.05    phreeqc
Fe    0.43    carbfix
Fe    1.25    actual
Mg    0.35    phreeqc
Mg    0.17    carbfix
Mg    0.08    actual
SO4    0    phreeqc
SO4    0    carbfix
SO4    416    actual


As you can see, the values range from 0 to 400. I want it to plot it in bars; when I am plotting it as you can imagine the values near zero don't show at all. So I am trying to make the y axis logarithmic. I have created the following code but it doesn't work. I get the bars with zero above and the others on top. 


ggplot(fc, aes(x = Temp, y = mean, fill = Glass)) + 
geom_bar(stat = "identity", position = "dodge", aes(y=log(mean))) 
+ theme_bw() + theme(panel.grid.major = element_blank(), panel.grid.minor = element_blank()) + theme(legend.position = c(0.45, 0.85), legend.title = element_blank()) 
+ scale_fill_brewer(palette = "Dark2") + scale_color_brewer(palette = "Dark2")


I would very much appreciate your help. I am stuck. 


Kind regards,
Maria