google sheetslocalizationtext formatting
In Microsoft Excel the following formula forces the month name to be displayed in Portuguese, regardless of the default language.
=TEXT(A1,"[$-pt-PT] dd mmmm yyyy")
Google Spreadsheets ignores the parameter [$-pt-PT]. How can I format dates to different language than the default on in Google Spreadsheets?
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).
I don't, except I suspect you are out of luck for the time being at least. However, even in Excel I have often found it as, or even more, useful to perform such grouping in the base data rather than in the pivot table. For me the summary provided by the table is often a prelude to drilling down for further detail and rather than end up then with many different extracts I find it much easier to filter the source data, which I have already formatted to suit me.
On that basis a hack of sorts may serve for you. Assuming data as in D:E in the image, I added three columns with formulae:
=year(D2) =month(D2)=weeknum(D2)To reduce the need for recalculation I usually then convert the results to values.
ColumnsA:C can then be included in the pivot table and, unlike Grouping, the components of the date can be split between rows and columns in the pivot table:
Best Answer