________________________________
From: webmaster-Kracked_P_P <webmaster@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 <webmaster@krackedpress.com> wrote:
From: webmaster-Kracked_P_P <webmaster@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+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
--
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
