can i do a bridge chart in excel for mac 2011

I am sure all the above points are enough to convince you to use a step chart instead of a line chart.I have a large workbook from which I am trying to build reports, including multiple graphs. Now, if you come to the step chart, it is clearly shown that you have two changes between Jul to Sep.

In step chart, you can clearly able to see there is always a constant period before any increase and decrease.Īctual Number of Changes In below two charts, an increase has occurred between Jul to Aug and then Aug to Sep.īut, if you look at the line chart, you are not able to clearly see both of the changes. On the other hand, in the step chart, you can see before the increase there is a constant period.Ĭonstant Periods A line chart is not able to show the periods where the values were constant.īut in step chart, you can easily able to show the constant time period for values. In short, in a line chart, you cant see the magnitude of a change but in a step chart, you can see the magnitude of a change.Īctual Trend A step chart can help you to show real insight into a trend.īelow, in both of the charts, you have a decrease in stock in May and then again increase in Jun.īut, if you look at both of the charts you will find that the trend of decrease, and then an increase is not clearly shown in the line chart. Just look at the below two charts where we have used stock in hand data.Īnd for the same period, in step chart, you can see that the increase has only happened in April. On the other hand, a line chart is more concerned about showing trends instead of the change. Step Chart Here we have some differences between a line chart and a step chart and these points will help you to understand the importance of a step chart.Įxact Time of the Change A step chart can help you to present the exact time of a change. So today, in this post, Id like to share with you a step by step process to create a step chart in Excel.Īnd, you will also learn the difference between a line chart and a step chart which will help you to select the best chart according to the situation.Īctual Number of Changes Simple Steps to Create a Step Chart in Excel How does it works How to Create a Step Chart without Dates How to Create a Step Chart without Risers Steps to Create a Step Chart without Risers Sample File Conclusion More Charting Tips and Tutorials Line Chart Vs. Now the bad news is: In Excel, there is no default option to create a step chart.īut, you can use some easy to follow steps to create it in no time.

In fact, it uses vertical and horizontal lines to connect the data points. Unlike the line chart, it doesnt connect data points using a short distance line.

In reality, a step chart is an extended version of a line chart. It can help you to present the trend as well as the actual time of a change.

Can i do a bridge chart in excel for mac 2011