Nasir has attended:
Excel Advanced course
Broken Column Chart
I am trying to create a Broken Column chart for something that I am working on. The bar graph itself contains 58 points that need to be plotted (I would like the bar chart to be plotted in order from the largest number to the smallest). The reason why we need to plot a Broken Column chart is because one of the figures is significantly larger then the other figures.
The largest figure is a value if 230, with the next largest value being 61. I would like the break of the graph to start at 100 and to resume at 200, with numbering on the Y-Axis to go from -100 (smallest figure is -78) to 250, with the axis being labeled after intervals of 50.
I would like the graph to look similar to the the column bar graph in the following link http://alesandrab.wordpress.com/2014/03/17/broken-column-and-bar-charts/
I have made an attempt at this myself, but it can get a bit confusing near the end. Any help on this is greatly appreciated. I have listed the 58 figures below.
Regards
Nasir
230
61
55
44
43
36
34
30
30
30
25
23
23
19
17
17
14
11
11
9
9
8
7
7
6
5
3
0
0
0
0
0
-1
-1
-2
-4
-4
-4
-4
-5
-5
-7
-10
-10
-11
-12
-12
-12
-13
-17
-23
-29
-30
-30
-39
-48
-65
-78
RE: Broken Column Chart
Hello Nasir,
Thank you for your post. Apologies for taking so long to reply, this is not the norm. The whole training team has been exceptionally busy this week but you will receive a reply with a solution shortly.
Kind regards
Marius Barnard
Excel Trainer
RE: Broken Column Chart
Hi Nasir
Sorry for taking so long to reply. The broken bar method is quite tricky and time consuming to create.
Can I suggest a different approach suggested by Jon Peltier?
http://peltiertech.com/broken-y-axis-in-excel-chart/
He suggests a Panel Chart rather than a broken axis.
If you want help with your Broken Column example it would help to send what you have created so far to info@stl-training.co.uk and ask to forward to Doug.
Regards
Doug Dunn
Best STL
RE: Broken Column Chart
Hi Doug,
Thanks for getting back to me. I managed to work out how to create the Broken Column chart as per the method in my original post by myself. It was a little bit complicated but I managed to figure it out.
I have come across the link you posted and this method also seems to be a little messy. Thanks for your help on this.
Kind regards
Nasir
RE: Broken Column Chart
Well done Nasir for creating the broken column chart. It seemed to becoming time consuming with so many data points. I will set up a small example with 5 bars for others to try.
Thanks for your question and for letting us know you solved it yourself!
Regards
Doug Dunn
Best STL