Display only certain values in pie and graph chart

Hi,

I have a table that contains some data. 

LabelName LabelValue
TotalForRetire 10337
dummy1 0
TotalForRelatives 5850
dummy2 0
TotalForDisability 7337
TotalForOrange 23

I have a pie chart and a bar chart.

In the pie chart I want to plot only TotalForRetire and TotalForDisability and TotalForOrange

In the bar chart I want to plot only TotalForRetire,dummy1,TotalForRelatives. Also, here I want the horizontal axis not to show the label  for dummy1 as the value is 0. How can i do that for each chart?

Thanks

September 3rd, 2015 10:08am

Hi collie12,

To create a pie chart, only display values when LabelName is equal to TotalForRetire orTotalForDisability or TotalForOrange, you can add a filter in category group based on this condition. Please refer to screenshots below:

To create a bar chart, only display values when LabelName is equal to TotalForRetire or dummy1 or TotalForRelatives, and hide dummy1 in category label, you can add a filter condition same as in the pie chart. And specify the category label with an expression. Please refer to screenshots below:

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

Free Windows Admin Tool Kit Click here and download it now
September 3rd, 2015 11:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics