Graphics 70

Drawings, charts, colors (not Multimedia!)

Sorted from new to old.

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

Sun 8AM

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

Sun 8AM

Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

Sep29

ProgressPie SVG

jQuery library to create ProgressPie SVGs. Simple, perfect, works

Feb10

3 Custom BS buttons

3 Custom-made button colors using Bootstrap. Because I suck at graphics, I ...

Jan21

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

Jan17

FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

2023Dec29

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21

Nearby Color shades

Calculate colors close to input color, a jquery html that will give you 10 ...

2023Nov8

3D Progressbar

CSS-JS animated Progress bar. Was looking for pregressbar in svg, couldn't ...

2023Aug18

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

2023May5

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

Img not found - Temp pic

Showing image not found if img src image is missing

2022May27

1 2 3 4 5