I automatically insert a line in Google Sheets, then my data on that line. this keeps pushing the last line of the chart. after a month, the line chart is so compressed as to not be very easy to pick out the latest data.
I am totally raw, the veriest tyro to Sheets and Charts, so this may be basic stuff. if there a way to set the chart axies to be the newest line through the last 500 lines ? I have an inkling that it might be easier to just use the first 500 lines, and insert a new line at the top of the Sheet. then to have the X axis display in reverse order from oldest to newest. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/11e2d217-0fe8-4e65-8199-71c44d4c9290%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
