Changing your dates to text
Your task is to format your dates as plain text so the user can plot a candlestick chart to show data from the
Open, Close, High and Low prices. You will do this in the inserted column, using a formula.本練習屬於課程
Google Sheets 的資料視覺化
練習說明
- Insert a new column so that
column Bis blank. - Type the heading "Plain Dates" in
B16. - Enter a formula in
B17usingtext()to show the date from the the same row incolumn Awith the same formatting but as plain text. - Copy the formula down from
B17throughB26and remove the dates that have popped up on your line chart.
