Calc - bar chart - does not list order properly for cell values

[webmaster-Kracked_P_P]

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

[Tom Davies]

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 <***@krackedpress.com> wrote:

From: webmaster-Kracked_P_P <***@krackedpress.com>
Subject: [libreoffice-users] Calc - bar chart - does not list order properly for cell values
To: "LibreO - Users Global" <***@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+***@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

[webmaster-Kracked_P_P]

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.
Loading Image...
I will get rid of the image in a few days.

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 :)
Subject: [libreoffice-users] Calc - bar chart - does not list order properly for cell values
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".
$'Royalty Checks'.$A$5:$B$31
$'Royalty Checks'.$A$5:$A$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.
.
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

[Tom Davies]

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

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

Post by Tom Davies
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 :)
Subject: [libreoffice-users] Calc - bar chart - does not list order properly for cell values
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".
      $'Royalty Checks'.$A$5:$B$31
          $'Royalty Checks'.$A$5:$A$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.
.
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

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

[webmaster-Kracked_P_P]

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.

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

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

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 :)
Subject: [libreoffice-users] Calc - bar chart - does not list order properly for cell values
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".
$'Royalty Checks'.$A$5:$B$31
$'Royalty Checks'.$A$5:$A$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.
.
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

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

[Tom Davies]

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

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

Post by Tom Davies
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 :)

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

Post by Tom Davies
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 :)
Subject: [libreoffice-users] Calc - bar chart - does not list order properly for cell values
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".
        $'Royalty Checks'.$A$5:$B$31
            $'Royalty Checks'.$A$5:$A$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.
.
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

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

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

[Andreas Säger]

Hi,

The Y-axis is a numeric scale with start, end and some interval.
The scale can be adjusted to be logarithmic or in reverse order. Just
double-click the chart and then the y-axis.
The order of the corresponding cell vector does not matter as long as
the cell values are numeric.

[Andreas Säger]

Post by Andreas Säger
Hi,
The Y-axis is a numeric scale with start, end and some interval.
The scale can be adjusted to be logarithmic or in reverse order. Just
double-click the chart and then the y-axis.
The order of the corresponding cell vector does not matter as long as
the cell values are numeric.

Correction: In a vertical bar chart the vertical axis is the x-axis. It
can be set to either one of "Automatic" (number or text), "Date" (number
with special intervals) or "Text". Text scales are shown in the order of
appearance, numeric scales are sorted ascendingly or descendingly. If
you have text data, there is no choice other than "Text".

[Gérard Fargeot]

I have just seen my post dont be sent.

Post by webmaster-Kracked_P_P
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".
$'Royalty Checks'.$A$5:$B$31
$'Royalty Checks'.$A$5:$A$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
<Loading Image...>
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.

[webmaster-Kracked_P_P]

Sorry
Been sick
Just picked up over 400 emails since last online.

The reverse order solution works.
I do not know why I need to check the reverse order option,
but it is what works.
.

Did you see these replys from Andreas and Gerard? (In my email they
appeared in a different location, and I noticed you didn't respond to
them.)
-- Tim
===========================
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

Post by Andreas Säger
Hi,
The Y-axis is a numeric scale with start, end and some interval.
The scale can be adjusted to be logarithmic or in reverse order. Just
double-click the chart and then the y-axis.
The order of the corresponding cell vector does not matter as long as
the cell values are numeric.

Correction: In a vertical bar chart the vertical axis is the x-axis. It
can be set to either one of "Automatic" (number or text), "Date" (number
with special intervals) or "Text". Text scales are shown in the order of
appearance, numeric scales are sorted ascendingly or descendingly. If
you have text data, there is no choice other than "Text".

Post by Andreas Säger
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.

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

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

Post by Tom Davies
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
Subject: [libreoffice-users] Calc - bar chart - does not list
order properly for cell values
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".
$'Royalty Checks'.$A$5:$B$31
$'Royalty Checks'.$A$5:$A$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.
.
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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

--
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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