Skip to Content
author's profile photo Former Member
Former Member

饼图显示数据问题?

饼图展示时怎样在饼图上同时显示数据和百分比;

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 25, 2009 at 03:52 AM

    用图表的功能选项直接将两种数据表示方式同时显示出来是很难做到的。提供三种方法供你参考:

    1.在图表专家中将u201C显示标签u201D和u201C显示值u201D同时选中,值的数字格式选择整数,预览后依次将每个扇形的标签手动的改为各自的占百分比。

    此方法的弊端是刷新报表后,标签中的占比值不会变化。

    2.在图表专家中将u201C显示值u201D选中,值的数字格式选择整数;用公式字段建立、计算每个扇形的占比然后将每个公式字段拖到相应的扇形上。

    此方法的弊端是刷新报表后,占百分比的位置不会变化,如果扇形的大小变化较大则占百分比的位置不能准确对应相应的扇形。

    3.在图表专家中将u201C显示值u201D选中,值的数字格式选择整数;复制该饼图并完全重叠与原饼图之上,并将新复制的饼图在图表专家中将u201C显示值u201D选中,值的数字格式选择百分数,拖动该百分数使其与原饼图上的整数不重叠。

    该方法的需要注意的是两个饼图完全重叠,其中一个饼图除了显示值需要显示外其余各部分均可设置为不显示或者透明的状态。

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.