First, you should rearrange the data range, insert three columns between the original two columns, give them header names as Base, Down and Up. If you have Excel 2013 and earlier versions, the Excel does not support this Waterfall chart feature for you to use directly, in this case, you should apply the below method step by step.Ĭreate helper columns for the original data:ġ. And you will get the waterfall chart as below screenshot shown:Ĭreate waterfall chart in Excel 2013 and earlier versions To color other data point columns one by one with this operation. To do this, please double click one data point, and then click Format > Shape Fill, then choose the color you need, see screenshot:
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |