Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


I have just seen my post dont be sent.



Gérard Fargeot wrote

krackedpress wrote
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.
Just check "Reverse direction" 
Reverse_Axis.jpg
<http://nabble.documentfoundation.org/file/n4009465/Reverse_Axis.jpg>  

It works for bar chart, column chart ...etc
It works with text value, numeric value...

Gérard





--
View this message in context: 
http://nabble.documentfoundation.org/Calc-bar-chart-does-not-list-order-properly-for-cell-values-tp4009346p4009702.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.