graphing scale

Hello

Can someone pls assist me with my graphing issue.

I have revenue by county, however my top performing county has $1M in revenue and the second best comes in at a mere $11k

can someone pls help me figure a way to make the scale on the graph look decent, visually?

thx u *see attached*

Maybe you could use a logarithmic chart. The LOG10 function will calculate the values.

It is difficult to plot chart values that are so different in value without confusing the reader.

Besides logorythmic diplays, you can make all values a ratio of the largest value and plot those final data points.

good luck

Steve=True