![]() ![]() I can see that the years are 5 years apart but the sequence as regards day and month is less easy to follow. I would prefer it if I could set the range of dates shown on the X axis and fix them at more clearly recognisable intervals. Would prefer the date to be rotated like the text on the spine of a book but appreciate that that might not be possible with the Calc program as it is at the moment. I don't particularly like the dates on the X axis taking up a lot of vertical space but much prefer them below the graph than in the middle. Spreadsheet with chart.ods Example spreadsheet with a chart in which I'd like to improve the presentation of data linked to dates (14.78 KiB) Downloaded 1195 times I wonder if anyone reading this is able and willing to guide me as to how I might be able to achieve a result more like what I describe above? I expect I'd be asking for something a bit too sophisticated if I asked for the points on the graph to be labelled with the values they represent, either permanently or as tooltips (value shown when point pointed to with mouse). If space on the X axis allowed (without having to have a vastly wide graph or overlaps in dates) I'd welcome being able to show an intermediate date as well e.g. 1 January 1982, 1 January 1983 and so on (and not the dates the program has currently chosen to display which do not represent an easily recognisable sequence). Ideally, I would have notches on the X axis (along with vertical guidelines), with the notches labelled to show at least one date per year, e.g. I think I'd prefer the dates to be shown below the graph, ideally rotated (like the title on the spine of a book) so, perhaps, the graph wouldn't need to be stretched out so much to avoid overlapping of dates. I don't particularly like the dates stuck horizontally in the middle of the graph, which is presumably a consequence of the graph showing both positive and negative values. The attachment shows some dummy dates and data just so people can see where I've got to now (not very far) and perhaps understand better where I'd like to get to. I hope Staffan will still come back with his own attachment/further queries so that, hopefully, his own specific needs can be met. Hope I'm not breaching etiquette by jumping in with a similar question and attachment ahead of the original poster.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |