Hi :) Ahah. I see what you mean now.
The oldest and lowest should be bottom left. Going up or to the right should be an increase. Sorry i didn't realise that it really was doing the wrong thing. Apols and regards from Tom :) >________________________________ > From: webmaster-Kracked_P_P <webmas...@krackedpress.com> >To: users@global.libreoffice.org >Sent: Wednesday, 26 September 2012, 17:36 >Subject: Re: [libreoffice-users] Calc - bar chart - does not list order >properly for cell values > > >Actually >If you want to have the exact amount listed next to the "bar" of the >column or bar chart, the way I have it set up was the only one that >worked Last year. > >If I have to change that, I would place it on a different printed page. >BUT if I want it show together, it needs to be a Bar graph. > >I need to have the oldest date on the left and the newest on the right >[or old on top]. But if I use a Column Chart, the "system" seems to >"insist" that the newest date [in a text format] be listed first [left >or top] and not last which is not the order of the column of data. > > > >On 09/26/2012 11:18 AM, Tom Davies wrote: >> 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 <webmas...@krackedpress.com> >>> To: users@global.libreoffice.org >>> 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 <webmas...@krackedpress.com> >>>> wrote: >>>> >>>> From: webmaster-Kracked_P_P <webmas...@krackedpress.com> >>>> Subject: [libreoffice-users] Calc - bar chart - does not list order >>>> properly for cell values >>>> To: "LibreO - Users Global" <users@global.libreoffice.org> >>>> 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: >>>> users+h...@global.libreoffice.org >>>> 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: users+h...@global.libreoffice.org >>> 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: users+h...@global.libreoffice.org >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: users+h...@global.libreoffice.org 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