00:00If you want to create a step chart that looks something like this, it is very, very simple.
00:04Let me show you how it's done.
00:06So this is the data set table that I want to make a step chart of.
00:09And this is the one that I'm going to create a temporary or a working table.
00:14So this is what you have to do.
00:15You have to exclude the first date.
00:17And then you select all of the dates like this.
00:20Control C to copy in the clipboard.
00:21And you're going to paste it over here on your new table here.
00:25Next, you're going to copy the guest price.
00:26You're going to copy from the beginning and exclude the last one.
00:30You're basically staggering the date and the price itself.
00:34Control C to copy.
00:35And you're going to paste it right here like this.
00:37Next, what you're going to do is that you're going to select everything on your data set table from your original table itself.
00:43Control C to copy.
00:45And go over here and Control V to paste it.
00:47And now to draw the chart, place your cursor anywhere on your new data set table here.
00:52And you press Control A to select the whole data set table.
00:55Go insert chart and a line chart.
00:59You're going to select this line chart.
01:00And you have a step chart.
Comments