Doug,
I rarely use charts in Calc, but, I looked at your example charts. I do
not know enough about this to even begin to duplicate the problem or to
intelligently post about it. Off hand, this first issue appears to be
incorrect, but, again, it is like asking me to explain women, I am clueless.
I am posting to the user forum to see if there can be clarification
_Bugs I am trying to report:_
_Charts_
1.
With the release of Ooo3.1, the ability to have a Column chart
with a choice for the data series x axis has disappeared. The x
axis defaults to the number of points chosen to be displayed for
the y axis of the series. No longer is there an ability for
selecting any x-axis data series. I have checked in Excel and find
that it doesn't have this problem. I have attached an example in
the DJIA_example.ods. In the X values for the series used to be
$A$40:$A$79. Now as you can see the X values are just shown as
1,2,3,....40 which has no real relevance to the data I attempting
to show in the chart.
I don't use the Bar Chart, but when I check the Chart Wizard to set
one up, I find that it also is limited to only the Y series. The net
result is that you can't do a Bar or Column Chart for a data range
versus another data range. This is a reduction from the chart
capabilities of OO2.x and SO9.x
First of all, I have no idea how to create the charts that you show
(looks like some kind of percentages are calculated and used for
display). I tried the following:
Open Calc document.
Use Insert > Chart
Select a column chart
Choose A40:B70 as my data
Set data to be in columns
Check First column as labels
This causes the first column to be a label. Is this not what you desire?
Off hand, my guess is no, so I probably do not understand.
Click next
From this next screen, you can indicate which columns are the data columns.
2 The other bug which occurred after upgrading to Ooo3.2 is shown in
the FUND_Example.ods attached. The information in the column chart
does not display until you click on the chart and do an edit. The the
data show up as in the DJIA_Example.ods.
_Bugs I am trying to report:_
_Charts_
1.
With the release of Ooo3.1, the ability to have a Column chart
with a choice for the data series x axis has disappeared. The x
axis defaults to the number of points chosen to be displayed for
the y axis of the series. No longer is there an ability for
selecting any x-axis data series. I have checked in Excel and find
that it doesn't have this problem. I have attached an example in
the DJIA_example.ods. In the X values for the series used to be
$A$40:$A$79. Now as you can see the X values are just shown as
1,2,3,....40 which has no real relevance to the data I attempting
to show in the chart.
I don't use the Bar Chart, but when I check the Chart Wizard to
set one up, I find that it also is limited to only the Y series.
The net result is that you can't do a Bar or Column Chart for a
data range versus another data range. This is a reduction from the
chart capabilities of OO2.x and SO9.x
2 The other bug which occurred after upgrading to Ooo3.2 is
shown in the FUND_Example.ods attached. The information in
the column chart does not display until you click on the chart
and do an edit. The the data show up as in the
DJIA_Example.ods.
Any comments would be appreciated.
Thank you,
Doug
when I looked at the second example, there was no data in the second
chart, but, it also showed the data range as empty.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
