How do I create a data table directly under my chart on Google spreadsheets? I want to achieve something similar to the figure below. In MS Excel it is called datatable and it is inserted by a click of a button.
Google-sheets – Insert a datatable directly under the chart in Google Spreadsheets
google sheetsgoogle-sheets-charts
Related Solutions
Basically what you're looking for is something like Pivot Tables of Excel, where you can group by anything you want.
Unfortunately there is no such support in Google Spreadsheet. What you (or someone) could do though is to write a simple script to group them for you. If you're interested you can start with some tutorials.
Maybe this has been fixed in New Google Sheets because it works for me (indeed, it is VERY simple):
Select A1:B3, Insert, Chart..., click Line chart, Insert.
Seems happy to work with DMY format and, as it happens, text for dates (since happening to be 4 months apart the x-axis spacing to be equal is about correct anyway).
Related Topic
- Google-sheets – Update Google Drive Chart based on which row selected
- Google-sheets – use Google Chart Gallery in Google Spreadsheets
- Google-sheets – Scatter chart with multiple data series
- Google-sheets – How to modify the range of an existing Google Sheets chart
- Google-sheets – How to embed a chart from a Google Spreadsheets in a Google Doc
- Google-sheets – How to skip columns in a Google Spreadsheets Chart
- Google-sheets – How to group certain data in a chart in Google Sheets
Best Answer
As far as I know, at this time charts in Google Sheets don't include a datatable option.
References
Create a chart or graph - Docs Editors Help
Editing and formatting your chart - Docs Editors Help