Hi - I haven't found much help in the doc or in the forums on this particular subject.

I have a stacked bar chart that looks pretty nice, but the problem is that it has many series' so my legend is HUGE. I would like to limit the number of series' to just the top 5.

Is there a feature somewhere in Advanced Graph assist that will set this for me? I'm working on building a hold file that just gives me the right data, but I'm hoping there is a way to do it in 1 step.

thank you!

This message has been edited. Last edited by: Kerry,

I would suggest that you pre-process the data for the graph to remove the unwanted series.

This could potentially be done by a BY HIGHEST 5 ...

Hi Waz!

Actually, that's what I thought I was doing, but it's still bringing back too many series.

 DEFINE FILE DASHBOARD
NET_UNITS/D10C=DASHBOARD.SEG01.U_PURCHASED-DASHBOARD.SEG01.U_RETURNED;
END
TABLE FILE DASHBOARD
SUM
     'DASHBOARD.SEG01.NET_UNITS'
BY 'DASHBOARD.SEG01.CATEGORY'
BY HIGHEST 5 'DASHBOARD.SEG01.C_SEGMENT'
ON TABLE NOTOTAL
ON TABLE HOLD AS TEMPDASH FORMAT ALPHA
END
GRAPH FILE TEMPDASH
-* Created by Advanced Graph Assistant
SUM TEMPDASH.NET_UNITS
BY TEMPDASH.C_SEGMENT
ACROSS TEMPDASH.CATEGORY
ON GRAPH PCHOLD FORMAT PNG 

I have a feeling this has something to do with the fact that the top 5 segments in each category aren't the same?

Be aware that BY HIGHESR n will return all highest n values, including ones that are equal.

e.g.

Values
1
2
3
4
5
6
6
7
8
8
9
10

By HIGHEST 5 Will return:
6
6
7
8
8
9
10


If this is the case, then you will need extra filtering to determine those records to toss.