Issue 43489 - Display both value and percentage as data point label
Summary: Display both value and percentage as data point label
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All Windows 98
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
Keywords: ms_interoperability
: 83752 (view as issue list)
Depends on:
Blocks: 82177
  Show dependency tree
Reported: 2005-02-24 16:35 UTC by matius_4
Modified: 2013-02-24 21:22 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

Example created with Excel XP (14.00 KB, application/
2006-11-06 12:20 UTC, gnustavo
no flags Details
TCS (9.46 KB, text/html)
2007-10-09 09:36 UTC, kla
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description matius_4 2005-02-24 16:35:19 UTC

I am a frequent user of Open Office and love how flexible the software has 
become. As a student there are some features I would like to see though.

When creating a Pie Chart I would like to be able to have the option to place a 
Pie Chart on a NEW full page sheet. I don't like having to resize the image and 
have to guess how big it will have to be when printing :D

My other suggestion is to be able to have this options within creating the pie 

Label: Just what the section of the pie chart represents

Label and Value: The value will show what number has been entered to get this. 
This value could be shown in both the legend or in brackets next to the pie 

Label and Percent: What percentage is each segment.

Label, Value and Percent

and finally a tick box to show/hide the Legend

The percent option I would benefit very much from as I am at college and am 
always having to do this with my pie charts. As you can imagine this can be 
quite time consuming without this. It also doesn't look as nice with it not 
being intergrated into the pie chart properly.

Thanks for looking at this suggestion if you have any more questions please 
feel free to ask.

P.S. These features I have mentioned are availiable in MS Excel. Can piecharts 
with those options be imported into Open Office without any problems?
Comment 1 kla 2005-02-25 11:10:46 UTC
Comment 2 matius_4 2005-02-25 12:44:35 UTC

I noticed you posted a full stop and changed the Target milestone. Does this 
mean you are considering this enhancement in the future but not sure of a date 

I am just confused as you've not said anything :D

Thanks very much if you have considered the enhancement. I'd just like a bit 
more info :D

Best Wishes

Comment 3 kla 2005-02-28 09:52:51 UTC
Sorry, but the full stop means:
Comment 4 matius_4 2005-03-06 18:18:36 UTC
Thanks for the link. Does this mean all my suggestions will be put onto the 
list. I have to admit not everything on that page makes sense to me :D

Best Regards,

Comment 5 IngridvdM 2006-03-08 18:50:14 UTC
Creating a chart as sheet is already targeted with Issue 5736.
Putting labels to the chart data points during creation is targeted with Issue
So what is remaining is to have the value itself and the percentage value both
in the datapoint label. I change the summary accordingly.
Comment 6 IngridvdM 2006-03-08 18:52:20 UTC
Please do write only one request in one issue the next time. Multiple requests
can not be handled correctly. Thanks a lot.
Comment 7 gnustavo 2006-11-06 12:19:07 UTC
I'm going to create an attachment containing a spreadsheet with an example of a
pie-chart built with Excel XP where the labels show both the value and the
percentage, separated by semi-colons.

Openning the spreadsheet with Excel 97 one can see just the percentages and not
the values.

Openning the spreadsheet with OOo 2.0.4 one can see just the percentages too,
with the difference that the percentages are shown with two decimal digits after
the comma.  With Excel 97, the percentages are whole numbers, without commas.

Comment 8 gnustavo 2006-11-06 12:20:50 UTC
Created attachment 40365 [details]
Example created with Excel XP
Comment 9 IngridvdM 2007-04-03 18:01:00 UTC
changed target to 2.x
Comment 10 IngridvdM 2007-07-23 14:42:09 UTC
changed target to 2.4
Comment 11 IngridvdM 2007-10-02 15:35:22 UTC
I fixed the following in CWS chart14:
I added the possibility to display the value at the same time with the
percentage value.
Excel does allow this only for pie charts. As far as I can see the im- and
export for this property for pies works. If there are still open issues with the
filter according this feature please use issue 82177 to describe them.
The semicolon separator from the attached example is addressed with issue
82051for the feature and issue 82177 for the im-/export.
Comment 12 IngridvdM 2007-10-02 15:44:37 UTC
For further details look at the specification.
->Thomas, please verify in CWS chart14.
Comment 13 kla 2007-10-09 09:36:47 UTC
Created attachment 48769 [details]
Comment 14 kla 2007-10-09 09:37:30 UTC
see ok in cws chart14 -> verified
Comment 15 kla 2007-11-19 13:04:48 UTC
*** Issue 83752 has been marked as a duplicate of this issue. ***
Comment 16 kla 2008-03-28 10:13:07 UTC
Seen ok in current master -> closed