Hi :) Yes, just reverse the axis. Put the months&years along the bottom. Then you can have as many as you like, and some to the end, crush them up, make them into a meaningful line-graph or whatever you like.
The way you are presenting information at the moment is very non-standard even tho it looks quite pretty. Conceptually "Time marches on", it doesn't crawl up/down the wall. Regards from Tom :) >________________________________ > From: webmaster-Kracked_P_P <[email protected]> >To: [email protected] >Sent: Wednesday, 26 September 2012, 13:37 >Subject: Re: [libreoffice-users] Calc - bar chart - does not list order >properly for cell values > > >The sheet is listed in month order. >The top of the column is the oldest and the bottom is the newest. > >What I want to see is the: >dates in the first column >the amounts in the second >and the chart to the right of the amount column. > >What was done before was to adjust the size of the chart to align the >bar with the row that has the information. > >What I get it the order of the bars with the newest dates first. For >some reason the system will change the manually set order of the data >ranges to what it wants, and not what I want. This chart will be >printed out next to the columns on a single page. I want as many years >included on the chart as I can find info from the records I am given. I >would like to show at least the past 3 or 4 years on the chart. > >Here is a partial screen clip of the printed page. >http://lungstrom.com/royalty-screen.jpg >I will get rid of the image in a few days. > >On 09/26/2012 08:37 AM, Tom Davies wrote: >> Hi :) >> It would be more normal to have the date along the x-axis, along the >> bottom. The amount of money should go up the y-axis. Otherwise, as you >> point-out, the graph looks weird. >> >> You could try reverse-date order? >> Regards from >> Tom :) >> >> >> --- On Wed, 26/9/12, webmaster-Kracked_P_P <[email protected]> >> wrote: >> >> From: webmaster-Kracked_P_P <[email protected]> >> Subject: [libreoffice-users] Calc - bar chart - does not list order properly >> for cell values >> To: "LibreO - Users Global" <[email protected]> >> Date: Wednesday, 26 September, 2012, 12:25 >> >> >> I use 3.5.6 on Ubuntu 10.04 64-bit >> >> I notice that when I create a listing of months and money going >> >> March 100.00 >> April 200.00 >> May 150.00 >> June 100.00 >> >> The graphs always give me the information from bottom to top. >> >> June - - - - - >> May - - - - - - - >> April - - - - - - - - - - >> March - - - - - >> >> I have manually changed the data ranges starting with the last item and >> ending with the first, but the column or bar graphs always seem to give me >> the same visual of last to first on the chart/graph. >> >> I do not know what is going on with this. I am dealing with a graph showing >> month and income is a bar chart, but having the current month on the left >> and the oldest month on the right just does not work for others. >> >> Here is the Data info in the "wizard". >> >> Data Range: >> $'Royalty Checks'.$A$5:$B$31 >> >> Data Series: >> column B: >> $'Royalty Checks'.$A$5:$A$31 >> >> Y-Values $'Royalty Checks'.$A$5:$B$31: >> $'Royalty Checks'.$B$5:$B$31 >> >> When I do a highlighting for bottom to top or top to bottom, the ranges and >> graph always is the same. When I revers the order of the beginning and end >> values for the cells, I still get the same order of the graph visual >> elements. >> >> I do remember that last year, when I created a chart like this with 3.3.x >> [late version] or 3.4.x [early version], it did work file. If I highlighted >> the top to bottom, it showed the order of the elements matching top to >> bottom. I placed the chart/graph next to the columns [in column C] so the >> value of the cell is in alignment with the bar on the chart's graphic. It is >> used to watch the trend of the income from that person's monthly royalty >> checks. Since the earlier spreadsheet was lost with a computer crash and >> the backup disk was damaged, I cannot go back to the old file and just >> update it. >> . >> >> >> >> -- For unsubscribe instructions e-mail to: [email protected] >> Problems? >> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >> List archive: http://listarchives.libreoffice.org/global/users/ >> All messages sent to this list will be publicly archived and cannot be >> deleted >> >> > > >-- >For unsubscribe instructions e-mail to: [email protected] >Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >List archive: http://listarchives.libreoffice.org/global/users/ >All messages sent to this list will be publicly archived and cannot be deleted > > > > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
