Use the value in D2 to create a red bar chart relative to the max value in column d =SPARKLINE(D2,{"charttype","bar"; "color1", "red"; "max",max($D$2:D)})