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.

Diese Übung ist Teil des Kurses

<Kurs>Datenvisualisierung in Google Sheets</Kurs>

Kurs ansehen

Übungsanweisungen

Insert a new column so that column B is blank.
Type the heading "Plain Dates" in B16.
Enter a formula in B17 using text() to show the date from the the same row in column A with the same formatting but as plain text.
Copy the formula down from B17 through B26 and remove the dates that have popped up on your line chart.

Interaktive praktische Übung

Verwandle Theorie mit einer unserer interaktiven Übungen in die Praxis

Übung starten