Hi

Is there a way to create an in-cell graph or sparkline (histogram) that plots my range of data from A1:A10 and highlighting the negative ones in red.

For example, -20 to -10 has 4 occurrence (red bar), -9.99 to 0 has 6 occurrence (red bar), 0.1 to 10 has 5 occurrence (blue bar)

If not, what is the best way to have an in-cell graph to illustrate that most of the data points are negative?

I tried to attach a sample data file but encountered problems in uploading.

thanks

LL