7 Replies Latest reply: Apr 18, 2012 5:18 PM by swuehl RSS

Changing the columns of a bar chart

padasala

Hi,

 

I would like to know if it is possible to keep the columns of a bar chart dynamic.  If I have 20 products, and I just want to show 5 products in a bar chart with respect to their performance, it it possible (Rather than keeping the bar chart static)??

 

So, during month one, if products 1, 2, 3, 4 and 5 have the highest sales, they will be shown in the bar chart and during month 2, if Products 2,3,5,8 and 9 have the highest sales, they will be displayed on the bar chart.


Thanks and regards,


Sunil

  • Changing the columns of a bar chart
    swuehl

    This should be no problem.

     

    I assume you have a chart with dimension product and as expression a sum of sales or similar.

     

    Using QV11, you could use dimension limits for this.

    Check the 'Restrict which values are displayed...' check box and then first option 'Show only largest 5 values'

    (Uncheck Others at the bottom part if needed)

     

    If you are using QV10, you could sort by y-value descending and limit the number of values shown in presentation tab to 5.

     

    Hope this helps,

    Stefan