EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB3645: How to create a pie chart without the metric name(s) displayed in the legend and data labels in MicroStrategy Web 9.x.


Community Admin

• Strategy


How to create a pie chart without the metric name(s) displayed in the legend and data labels in MicroStrategy Web 9.x.

SYMPTOM
A user creates a Pie chart in Strategy Web 9.x. by placing both the desired attribute and metric into the columns, as shown below. 

ka04W000000OaZqQAK_0EM4400000026rp.png

 
This creates a pie chart that displays the metric name(s) in all of the data labels, as shown below.
 

ka04W000000OaZqQAK_0EM4400000026rt.png

 
CAUSE
This is working as designed. When an attribute is placed into the columns above the metrics, it is considered a cross-tab attribute. For each cross-tab attribute element combination, there could be more than 1 metric and it becomes necessary to identify the metric in the legend. However, under the 1 metric scenario, it is irrelevant.
 
ACTION
Follow these design changes to format the pie chart correctly.

  • Place the desired attribute(s) into the rows, and the desired metric(s) into the columns.
  • Right-click on the chart - Format - Advanced - Set Series: By Row, as shown below.
ka04W000000OaZqQAK_0EM4400000026rx.png
  • The pie chart should now look as below.
ka04W000000OaZqQAK_0EM4400000026rz.png

Alternatively, if the metrics were moved to the rows and the attribute kept in the columns, due to the fact that the default setting for the "Set Series" property is "By Column", the design shown below:

ka04W000000OaZqQAK_0EM4400000026rr.png

 
Will produce the following pie chart:
 

ka04W000000OaZqQAK_0EM4400000026rv.png

 
Article Reference Number: KB3645


Comment

0 comments

Details

Knowledge Article

Published:

June 24, 2017

Last Updated:

December 6, 2018