Is it possible to have Table grid and Graph together in R at row level

[aditee]

Hi Team,

Please refer the attached screenshot to understand my query.
Status column ( in the screenshot ) is row level data and i want to show it in as a graph where as remaining columns are grid type.

I want to display in the same way as it is present in the picture.

is it possible to achieve this in R

[andresrcs]

Yes, it is possible, take a look at this similar thread

Report with compound values and charts together

I have an existing report that I want to convert into R. It looks like this: [image] It has 5 distinct columns, there's the name, the horizontal bar chart, actual values, guideline values, and a time series spark style chart. I can produce all 5 of the bits, but I can't quite wrap my head around how to bring them together and line them up properly. It looks like there are a number of possibilities all with pretty significant challenges: Put it in an RMarkdown table: Seems like it would help line things up but will require building the table row-by-row. And putting ggplot inside of a table seems to have some challenges Build the whole exhibit in ggplot... lol wut?!?!? Not with my ggplo…

[aditee]

Hi,

Thank for the reply but my no. of row is not constant here, so how the alignmenet of graph will always be in the same line with the data table?

Regards
Aditee

[andresrcs]

Sorry I don't understand what you mean, could you make a minimal REPRoducible EXample (reprex)? A reprex makes it much easier for others to understand your issue and figure out how to help.

If you've never heard of a reprex before, you might want to start by reading this FAQ:

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

[aditee]

Hi,

Sorry for the delayed response.

I am attaching 1 dataset screeshot.

So if you open it, i want the data of column B,C,D, E in grid form and column k ("step") data as a graph and it should display row wise.
There are 5 value for column "K and accordingly graph should look like.

Please note the no. of row in excel is not constant and will change everytime. So if a new row is coming,accordingly graph data along with grid data should appear.

Please let me know if it is possible with R?

I am attaching data set screenshot here and will attach Requirement image separately as it is not allowing to attach 2 image.

Regards
Aditee

[aditee]

Please find the requirement image

[andresrcs]

Please read the link I gave you before and provide a proper reproducible example or at least sample data on a copy/paste friendly format, screenshots are not very useful for this.