如何在ggbarplot图形中排序y值?

我无法排序y值!

这里是一个例子:

N

我添加了sort.val =“ desc”来调整图形中y-值的顺序:

M

结果为错误

Public Function AuditChanges(RecordID As String,Useraction As String)
On Error GoTo auditerr

Dim db As Database
Dim rst As Recordset
Dim clt As Control
Dim userloging As String

Set db = CurrentDb
Set rst = db.OpenRecordset("Select *from audit_tbl",adopendynamic)

UserLogin = Environ("username")
Select Case Useraction
    Case "new"
        With rst
            .AddNew
            !\[DateTime\] = Now()
            !\[username\] = UserLogin
            !\[FormName\] = Screen.activeForm.Name
            !\[action\] = Useraction
            !\[RecordID\] = Screen.activeForm.Controls(RecordID).Value
            .Update

        End With

    Case "Delete"
        With rst
            .AddNew
            !\[DateTime\] = Now()
            !\[username\] = UserLogin
            !\[FormName\] = Screen.activeForm.Name
            !\[action\] = Useraction
            !\[RecordID\] = Screen.activeForm.Controls(RecordID).Value
            .Update
         End With

    Case "edit"
        For Each clt In Screen.activeForm.Controls
            If (clt.ControlType = actextBox) _
                Or (clt.ControlType = accomboBox) Then
                If Nz(clt.Value) <> Nz(clt.OldValue) Then
                    With rst
                        .AddNew
                        !\[DateTime\] = Now()
                        !\[username\] = UserLogin
                        !\[FormName\] = Screen.activeForm.Name
                        !\[action\] = Useraction
                        !\[RecordID\] = Screen.activeForm.Controls(RecordID).Value
                        !\[FieldName\] = clt.ControlSource
                        !\[OldValue\] = clt.Value
                        .Update
                    End With
                End If
          End If
    Next clt
End Select
rst.Close
db.Close
Set rst = Nothing
Set db = Nothing

auditerr:
    MsgBox Err.Number & " : " & Err.Description,vbCritical,"Error"
    Exit Function

End Function

我该怎么办?

ttc123 回答:如何在ggbarplot图形中排序y值?

这不使用ggbarplot,但可能会为您提供所需的东西,我想这会使VC领先于OJ:

library(tidyverse)

df2 %>% 
  mutate(supp = factor(supp,levels = c("VC","OJ"))) %>% 
  ggplot(aes(x = dose,y = len,fill = supp)) +
  geom_col(position = "dodge") +
  scale_fill_manual(values = c("gray50","black"))

关键是#2,它可以按我们想要的顺序手动重新调整supp中的因子。

本文链接:https://www.f2er.com/2704300.html

大家都在问