250 questions
1
vote
1
answer
72
views
Include plotly chart in DT rows R
I am searching to include plotly charts in a column of a DT table in R, similar to sparkline package.
I can't get the plotly objects to render. My current trials give empty column or having the html ...
- 5,583
0
votes
0
answers
28
views
handle undefined sparkline data
I am using cellRender = 'agSparklineCellRenderer.
For some rows the data for the sparkline cell is undefined.
This results in warnings of the form AG Charts - Option `series[0].xKey` is required and ...
- 880
2
votes
1
answer
91
views
How to add tooltip labels in R Sparkline?
I have sample code to add sparklines to DT datatable which work except for customising the tooltip in sparkline (from the sparkline package).
library(sparkline)
library(formattable)
library(DT)
...
- 23
0
votes
1
answer
89
views
How to refine fiddly overpainting of delegate rows in a QTreeView?
At the center of my python/Qt application is a tabular view using QTreeView. In one column, I have implemented sparklines by subclassing QStyledItemDelegate, and setting the data items in the ...
- 129
1
vote
1
answer
260
views
MUI Sparkline: show the showHighligh always and with different colors based on condition
I have a sparkline chart from MUI for react as follows
import * as React from 'react';
import Stack from '@mui/material/Stack';
import Box from '@mui/material/Box';
import { SparkLineChart } from '@...
- 797
2
votes
1
answer
168
views
How to set multiple colors for bars in ApexCharts horizontal bar chart (sparkline mode)?
I'm trying to create a horizontal bar chart using ApexCharts in sparkline mode. I want to set different colors for each bar, but I'm unable to achieve this using the colors option.
Here's my code:
...
- 108
0
votes
1
answer
136
views
Vuetify Sparkline with long x-axis but keep height the same
Vuetify 2. I am trying to make a Sparkline with a very long x-axis, so I want it to have a horizontal scrollbar (otherwise the labels are unreadable). I also want it to be inside a Sheet (so that I ...
- 143
0
votes
2
answers
285
views
Google Sheets: How to integrate two GOOGLEFINANCE tables horizontally using QUERY?
I have a problem that I unfortunately cannot solve on my own! I have the following formula:
=SPARKLINE(
QUERY(
{
GOOGLEFINANCE(S27; "price"; R27; R27+30);
GOOGLEFINANCE(&...
- 1
0
votes
0
answers
38
views
Sparklines sourcedata
If sourcedata for sparklines is a string, how can you advance the string by six rows repetitively to fill multiple sparkline graphs
Sourcedata =“d5:s5”
To correct syntax for
Sourcedata = “d5+6:s5+6”
...
2
votes
2
answers
99
views
Openxlsx2: Ability to create_speaklines in a group
I'm using openxlsx2 in R/Posit to create sparklines and hoping to create one group all at once. Excel allows the user to edit a group of sparklines at one time which makes it easier than editing a ...
- 21
1
vote
1
answer
320
views
Vuetify v-sparkline component not rendering
I was wondering If I could get some help with sparkline graphs in my component, as I'm still very much new to this.
For now, I just want to display a graph with default settings and an array of ...
- 11
0
votes
1
answer
114
views
PowerBI Report Builder: Sparklines - 'Align Axes In' option is missing from the Axes options
I'm using a sparkline column chart and the columns are autosizing where I have missing data, instead of showing all 6 categories and leaving a space where the zero value should be (see image).
The ...
- 33
-1
votes
1
answer
317
views
Create a Sparkline Bar Chart Within a Pandas Dataframe Column
I am looking to replicate the image below in a pandas dataframe within a Jupyter notebook. The title of orders in 2020 is not needed. I discovered this page https://github.com/crdietrich/sparklines/...
- 373
2
votes
1
answer
213
views
What is breaking the tooltips in this Quarto dashboard?
I have some sparklines embedded in html tables in my reports. I have been experimenting with using Quarto dashboards now for my reports. However, the width of the sparkline tooltip text blows up to ...
- 2,492
1
vote
1
answer
92
views
r/sparkline/win&loss/chnage bar colors [duplicate]
Working on a win/loss sparkline in R. Data coded 1 for win and -1 for loss. Can get basic structure with ggplot and following code:
puck <- data.frame(game=c("g1", "g2", "...
- 11
1
vote
1
answer
303
views
google sheets sparkline column type byrow with Ymin & Ymax columns byrow too
Recently I found a method really useful to have an "arrayformula" for the sparkline function.
As you can see in the sparkline byrow file in the I2 cell there is the only formula but I'm not ...
- 15
1
vote
0
answers
178
views
How to combine summary row and sparkline in a gt table?
I would like to have sparkline charts from the gtExtras package not only for my data rows but also for the summary rows in a gt table. Is this possible?
So far i have sparklines only for the raw-data-...
- 11
0
votes
1
answer
203
views
Customizing sparkline tooltips for bar type
I would like the tooltips to read "one, two, three", instead of "0, 1, 2" in this sparkline plot created with the R sparkline package.
Although I don't see this anywhere in the ...
- 2,492
-1
votes
1
answer
151
views
Creating a categorical heatmap with sparklines?
Does anyone know of an example of how to create a categorical heat map with individual sparklines within each cell? Or have a suggestion on how to use matplotlib's annotation to produce this (or ...
- 2,486
0
votes
1
answer
101
views
Two different tooltip in highcharts sparkline
I'm working with sparkline, but I have a two differents graphs of sparkline: one is a quarter profit of company (EUR), but the other is a difference between the present year with before and it's show ...
- 3
0
votes
1
answer
314
views
How to add sparklines in gt package?
I want to create a table which show how data changed in past months. I've been trying to do it in gt package I couldn't understand why it doesn't work.
example data
df <- data.frame(
group = c(&...
- 89
0
votes
0
answers
165
views
Is there a way to make a notification in Google sheets that is based on a date or a percentage?
I'm working on creating a house maintenance spreadsheet and want to create a notification popup or sparkline that is visual that shows me the the completion level of the tasks. Is there a way to make ...
0
votes
0
answers
317
views
jQuery Sparkline is not working for me. What am I doing wrong?
I tried to emulate the example provided by https://omnipotent.net/jquery.sparkline/#s-docs, since I want to work with JQuery Sparklines for a project.
This is what my attempt displays
I downloaded ...
- 13
-1
votes
1
answer
175
views
highcharts sparklines how to scale x-axis in each row to the same
i am using highchart sparklines in my table. This is my code to generate the sparklines. It is generated using a php script. So you will find some php variables inside:
$(function () {
...
- 197
0
votes
1
answer
62
views
In line plot using R spec_plot not working
I am strugling with spec_plot() in a tbl kable, example in the code below. When I try to add the inline plot in the column "chart" of the table, it returns the error Error: x must be a ...
- 51
1
vote
3
answers
690
views
How to change last two column colors in sparkline charts
In Google Sheets, sparkline charts is known to have an option to change the last column color.
=sparkline((A1:A5),{"charttype","column";"lastcolor","green"})
...
- 283
0
votes
0
answers
623
views
How to scale sparkline chart relative to cell height in Google Sheets
In Google Sheets, the sparkline formula appears to fill a chart fully into a cell, whatever cell width and cell height is.
Is there any option to scale the chart height relative to the cell height, ...
- 283
0
votes
1
answer
267
views
Sparkline formula parse error (not locale)
I'm getting "formula parse error" for the following formula in Google Sheets:
=SPARKLINE(D3,{“charttype”,“bar”;“max”,MAX($D$3:$D$69)})
I'm in the US, so this fits the US syntax. To no avail,...
0
votes
1
answer
304
views
How to create a Sparkline chart for for a particular name with values depending on the fields of other cells?
I need help creating a sparkline chart for an example data as below:
name
timestamps
test
action
try 1
2022-11-16 22:39:35.653819+00:00
TRUE
TRUE
try 2
2022-11-16 22:39:33.171203+00:00
TRUE
TRUE
try 1
...
- 193
2
votes
1
answer
500
views
Add Sparklines to Multiple Columns of R Data Table using Sparkline package
I am trying to add sparklines to multiple columns of a Data Table in R. I am able to get a single Sparkline column to render correctly, but when I try to render a sparkline in a second column based ...
- 21
0
votes
1
answer
263
views
Sparkline chart in NextJS does not render anything
I tried to replicate the example shown at Syncfusion but the Sparkline chart isn't rendered at all, neither shows any error. I'm doing it with NextJS.
import { SparklineComponent, Inject, ...
- 29
1
vote
1
answer
280
views
kableExtra with spec_plot saved into tex
I am struggling to create a latex table that also has the shape of distributions by group in one of the cells, as sparklines. I tried using kintr::kable and kableExtra packages with the spec_plot ...
- 879
0
votes
2
answers
1k
views
How to properly normalize sparkline column chart in Google Sheets
See image below for reference.
When I simply create a column chart of the items in column A, I get what seems like improperly scaled columns? 5 looks like just a line where 10 would seem to fully ...
- 119
0
votes
1
answer
203
views
How to add a sparkline to Table or Matrix in PowerBI
In the Microsoft guide they say that you need to check a box in the preview feature settings in order to use a sparkline, but I can´t find this box to check.
I am using Version: 2.97.921.0 64-bit (...
- 77
1
vote
1
answer
259
views
How to define the color of regular observations in "sparkline" package in R?
I'am using the Sparkline package in a dataset with three observations for years 2000, 2019 and 2020. I have defined colors for max and min values, but I can't find a way to make a dot appear in the ...
- 198
1
vote
0
answers
629
views
Editing sparkline tooltip (line graph) using spk_chr
I'm having issues customizing the tooltip for sparkline line graphs using the sparkline wrapper for R.
ATTEMPT #1:
While I was having some success customizing the tooltip for bar charts via the ...
2
votes
1
answer
484
views
Bootstrap DataTable Sparkline not working if Table set to Responsive
I have a Bootstrap DataTable with a sparkline in the last column, here is the full js:
$(document).ready(function() {
var groupColumn = 0;
let table = $('#example').DataTable({
//responsive: ...
- 65
0
votes
0
answers
347
views
How to draw sparklines in a matrix in Power BI Desktop?
I am having a Measure table which is having a structure like this:
What I want to do is to add sparkline chart beside column "c" in this Measure table. I am emphasizing on Measure table, ...
- 15
0
votes
1
answer
842
views
How to use Power BI Sparkline like Excel
Is it possible to create a sparkline in power bi desktop without using date. for example I have 3 columns which have their own values. I want to show these values in a column which is a sparkline ...
- 15
0
votes
1
answer
759
views
I am using ag-grid enterprise licensed controls and want to use ag-grid BarSparklines inside grid cells
I had followed every step of ag-grid documentation as stated in link below:
https://www.ag-grid.com/angular-data-grid/sparklines-bar-customisation/
My grid cells definition is as follows:
this....
0
votes
1
answer
370
views
How to use native Google Sheets formulas in Google Script?
I am struggling trying to create a formula that results in an array to feed the formula sparkline(). How can I call formulas into the script? So far I have:
function historic(term) {
var data = '=...
0
votes
0
answers
812
views
Add a non continuous range as a data source for sparkline in VBA
I would like to ask if it is possible to add a non continuous range as a data source to create a sparkline. Without VBA it can be done by creating a named range, provided that data are on the same ...
- 1
0
votes
1
answer
386
views
Sparkline Gantt Chart selecting earliest date from column and latest from another columns when i want individual dates to be displayed
I am struggling with a Gantt chart/ sparkline distinguishing unique trade numbers and dates as it aggregates all the inputted data and illustrates either the earliest date and latest date so all the ...
0
votes
2
answers
735
views
How do you insert a sparkline in excel without using [closed]
How can I create a Sparkline in Excel without going into the "insert" tab?
I'm looking for a formula or formula-like input I can write into a cell to generate the Sparkline.
Idealy something ...
- 3,103
1
vote
1
answer
1k
views
Sparklines in Power BI with SVG
I am creating some sparklines for a Power BI report using svg and manage to create the sparkline as expected. What I need is to change the color of the line after some specific point (x-axis is date ...
- 11
0
votes
1
answer
424
views
Google Sheet Sparkline for every nth column
I would like to add a Sparkline to a sheet showing the evolution of a value.
My table looks like this
value #1
diff former value
value #2
diff former value
value #3
diff former value
Sparkline here
...
- 6,910
0
votes
1
answer
161
views
Changing the minimum value for bullet chart in sparklines R package
I'd like to add a minimum value to a bullet graph using the sparklines R package. The default sets the minimum value to be 0.
sparkline(c(30,15), type = "bullet")
With chartRangeMin:
...
0
votes
1
answer
229
views
ModuleNotFoundError: No module named 'future.builtins'; 'future' is not a package
import sparklines
ModuleNotFoundError Traceback (most recent call last)
<ipython-input-32-3de868bf8913> in <module>
----> 1 import sparklines
~\anaconda3\lib\site-...
- 233
1
vote
2
answers
503
views
Apply gtExtras::gt_sparkline to multiple columns
Based on example code for sparkline from this link:
library(gt)
library(gtExtras)
mtcars %>%
dplyr::group_by(cyl) %>%
# must end up with list of data for each row in the input dataframe
...
- 10.1k
1
vote
1
answer
36
views
How to make a cell dynamically display an average % according to chosen time period?
I want this cell to output the average value according to the time period chosen.
If I choose 7 days, the cell should display the average value for the last week / 7 days.
If I choose 6 months, it ...
- 555