![]() ![]() Then insert the line chart by clicking Insert > Insert Line or Area Chart > 2-D Line chart, and you will get the below chart:ģ. Create the chart data as above step1 – step3, see screenshot:Ģ. If your data is year column instead of date column, the above steps may not work well, the following steps can do you a favor.ġ. And now, your step chart has been created successfully, see screenshot: Your data has been created, now, please select the new data range, and then click Insert > Insert Line or Area Chart > 2-D Line chart, see screenshot:ĥ. After that, copy all the original data table and paste them below the new range you have just created, see screenshot:Ĥ. Then go on copying the total order cells from B2 to B11, and paste them into column F, see screenshot:ģ. ![]() First, you should create the chart data, please copy the date cells from A3 to A12, and paste them into another column, column E as following screenshot shown:Ģ. This article, I will talk about how to create a step chart step by step in Excel worksheet.Ĭreate a step chart based on date column in ExcelĬreate a step chart based on year column in ExcelĬreate a step chart based on date or year column with a simple featureįor example, you have a range of data as shown in the screenshot below, to create a step chart, please do as this:ġ. But, there is no direct way to create it in Excel. ![]() A step chart is used to show the changes happened at irregular intervals, it is an extended version of a line chart,and it uses vertical and horizontal lines to connect the data points as following screesnhot shown. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |