How to display a plot next to a table (word export) ?

[bpauget]

dear all,
I'm trying to generate a word document containing a table (flextable::regulartable) next to a plot from a shiny app.
Does someone have an idea?
Thanks !

Here is the wanted result:

.

library(flextable)
library(dplyr)
df<-data.frame(c("A", "B"), c(1, 2))
colnames(df)<-c("Letters", "Numbers")
df<-df%>%
  regulartable()
plot<-plot(1,1)

r df

[pieterjanvc]

Hi,

Unfortunately as far as I know layout definition for word documents if quite limited... HTML and PDF have much more flexibility in that regard.

My suggestion would be you combine the table and plot as one figure, then insert it as a whole. This can be easily done with the gridExtra package. Here is an example:

library(gridExtra)
library(ggplot2)

data(iris)

myTable = tableGrob(iris[1:10,])
myPlot = ggplot(iris, aes(x = Sepal.Length, y = Sepal.Width)) + geom_point()

grid.arrange(myTable, myPlot, nrow = 1)

This is an extreamly basic example, but you'll get the idea There is a lot of online information on getting good layouts and editing tables.

Hope this helps,
PJ

[bpauget]

@pieterjanvc

library(gridExtra) library(ggplot2) data(iris) myTable = tableGrob(iris[1:10,]) myPlot = ggplot(iris, aes(x = Sepal.Length, y = Sepal.Width)) + geom_point() grid.arrange(myTable, myPlot, nrow = 1)

Thanks a lot for your response,
I had already seen this solution but unfortunatly, the table isn't editable in the word.
best regards !
Ben

[pieterjanvc]

Hi,

I agree, it's not a great solution, because having a table as an image limits its usability a lot, but you know how difficult it is in word (even manually) to align two pictures or table and picture on the same row without it jumping around ...

One other idea would be you force the document to have two columns (if that's even possible, maybe through a template) and have each in one column. I found a post where they managed it for powerpoint:

rmarkdown: how can you show the title and the content of a two column slide in the same slide?

So, I haven't actually made one of these before, but I was able to get a two column layout with title working by playing around with some things: Since it uses a template (as you're doing), I modified from the 2d example in the sol-eng GitHub repo. The section that references two-columns wasn't actually using two columns. So, I modified it to follow the pattern from the 2c vignette you referenced: ### 4. Two Content :::::::::::::: {.columns} ::: {.column} * This layout has a placeholder for a title and two placeholders for content. * This layout is used when you specify two columns for a content slides at the slide level. ::: ::: {.column} ``` :::::::::::::: {.columns} ::: {.column}…

Good luck, keep me posted!
PJ