Is there a way to create a broken bar graph in Excel?

[Scott Huish]

Is there away to create a broken bar graph in Excel? My data is so vastly different that I want the lower part of the graph to reasonably show the lower values on the graph and then break the graph and then a different scale at the top for the higher values?

LETTER	AMOUNT
A	157​
B	255​
C	1,796​
D	69​
E	48​
F	8​
G	30​
H	21,595​
I	307​
J	105​
K	8,005​
L	1,368​
M	76​
N	346​
O	1,018​

This isn't real helpful:

 

[Cubist]

For skewed data, try log-scale. Click on the y-axis -> Logarithmic scale.

 

[Scott Huish]

That's interesting, except that although that might be correct, the H value there doesn't visually look like anywhere around 20,000

 

[Cubist]

It's not meant to be 20,000. The log scale transforms data, bringing the larger values closer to the other values.

For example:
100,000 = 10^5 so log(100,000) = 5
100 = 10^2 so log(100) = 2.

Instead of plotting 100 vs. 100,000, it's visually better to plot 2 and 5.

 

[dreid1011]

There is this combination of two graphs: ms excel broken bar graph - Google Search

 

[Scott Huish]

I'll work on it tomorrow. But that's the easiest thing I've seen. The only thing I would change to that procedure is not return 0 if it isn't the MAX I would return NA so it doesn't plot those points at all.

Microsoft really should create a way to do this without workarounds though.

 

[dreid1011]

I'll work on it tomorrow. But that's the easiest thing I've seen. The only thing I would change to that procedure is not return 0 if it isn't the MAX I would return NA so it doesn't plot those points at all.

Microsoft really should create a way to do this without workarounds though.

Agreed.