How to make plot show the dates in the x-axis, and not the months?

General
,
#1

Hello! I am back with a new problem. Right now I am working with a dataset, where I wish to show how the concentration in totp (total phosphorus) changes throughout the season. I've imported my dataset from excel into r-studio, and by using this code I've changed one of the columns into date and made a plot:

utlop <- utlop %>%
mutate(Date = lubridate::dmy(Date))

class(utlop$Date)

ggplot(data = utlop)+geom_line(mapping = aes(x=Date, y=Totp))+labs(title = "Total Phosphorus measured at the outlet of x")

This gives me a plot, where everything looks great except I want the x-axis to show the specific dates the samples were taken. Right now it looks like this:

Screenshot 2023-10-30 at 13.37.27
Screenshot 2023-10-30 at 13.37.271136×838 64.2 KB

It only shows the months, not the specific dates. I also do not wish to include unnecessary dates, only the dates from the sampling. I will also include a picture of my dataset:

Screenshot 2023-10-30 at 13.39.21
Screenshot 2023-10-30 at 13.39.21434×558 101 KB

Thanks in advance for the help!

#2

Hi @Aurora99, remember put a reproducible example of data, like this:

Other way is paste the result of

dput(head(youdataframe,20)) # Put the name of you data frame. Is for get the 20 first rows a columns. 

fechas <- as.Date(c("2023-04-23", "2023-05-15", "2023-06-08", "2023-04-05", "2023-06-20"))

#  data frame
df <- data.frame(Fecha = fechas)

# Extract month of a date column
df$Mes <- format(df$Fecha, "%b") # names of month

# plot
ggplot(df, aes(x = Mes)) +
  geom_bar() +
  labs(title = "Frecuencia month",
       x = "month",
       y = "Frecuency")

image
image572×562 3.94 KB