Re: [libreoffice-users] Calc - bar chart - does not list order properly for cell values

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 <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
-- 
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