I need to make a chart showing weekly activity for the current week, with each day of the week as a point on the X axis. Example:
This works fine, but the problem I'm having is that, if today were wednesday, there's no data for Thursday-Saturday. Currently the chart depicts this by sending the line back to 0. Is there any way to make Google Charts stop drawing the line at a specific point and leave the other data points empty?
I tried omitting the missing values from the dataset, but that just causes it to stretch Sunday-Wednesday across the entire graph.
Use noData() method to enable "No data" label: chart. noData().
Double-click the chart you want to change. At the right, click Setup. Select the cells you want to include in your chart. Optional: To add more data to the chart, click Add another range.
Google chart tools are powerful, simple to use, and free. Try out our rich gallery of interactive charts and data tools.
You have to pass the value null
, which is Javascript's way of saying nil
. Make sure you don't include quotation marks.
For instance:
["Sat", null, 165, 210]
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With