3/7/2024 0 Comments Excel 2d histogram![]() ![]() The credit for this technique goes to Jon Peltier of. Creating a Step Chart in Excelįirst things first. Now let’s go ahead a look at how to create a step chart in Excel. Hope I have established some benefits of using a Step Chart over a Line Chart. Similarly, a line chart shows a slight decline from September to November, while the step chart would tell you that this was the period of inactivity (see image below). It gives you the impression that the petrol prices have gone up consistently during May 2015 and June 2015 (see image below).īut if you look at the step chart, you’ll notice that the price increase took place only on two occasions. Here is an example of both the line chart and step chart – created using the same data set (petrol prices in India).īoth of these charts look similar, but the line chart is a bit misleading. You can easily spot the time period where there was no change and can compare the magnitude of change in each instance. On the contrary, a step chart shows the exact time of change in the data along with the trend. The focus in such charts is the trend and not the exact time of change. ![]() Creating a Step Chart using the “Line Chart technique”.Ī line chart would connect the data points in such a way that you see a trend.The difference between a Step Chart and a Line Chart. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |