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.
