Data Studio
2.4K members online now
2.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Time Series Chart with Google Sheets Data

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm uploading data through Google Sheets. The data ranges from three years with data for each month. the time series chart shows up as a bar graph instead of a line graph, I cant seem to change it. Also, when I hover over the chart, all metrics say '0' even though the vertical axis and the chart obviously have imputed metrics. Initially I had data for every week of that time frame and experimented with a smaller set of data which showed the line and the mentrics when I hover so I condensed the data to 1/4 the size by doing it by minth. Still isnt working please help. 

Time Series Chart with Google Sheets Data

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

click on the text bar graph, it should allow you to change it

Time Series Chart with Google Sheets Data

Participant ✭ ✭ ☆
# 3
Participant ✭ ✭ ☆

How is your date formulated? If it's just YYYYMM then it won't work in a line chart. Try adding a day (01) after the YYYYMM and set your data range dimension to that new date field. Then you should be able to pull the month into a line chart.