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.Este ejercicio forma parte del curso
Data Visualization in Google Sheets
Instrucciones del ejercicio
- Insert a new column so that
column B
is blank. - Type the heading "Plain Dates" in
B16
. - Enter a formula in
B17
usingtext()
to show the date from the the same row incolumn A
with the same formatting but as plain text. - Copy the formula down from
B17
throughB26
and remove the dates that have popped up on your line chart.
Ejercicio interactivo práctico
Pon en práctica la teoría con uno de nuestros ejercicios interactivos
