Sort the chart based on a field not there in the Chart

This is my sample data on which i am trying to create a graph
Field A                      Field B (Count)                     Field C(Order)
Answer1                      4                                           0
Answer2                      1                                           1
Answer3                      3                                           2
Answer4                      5                                           3

I have used a chart which displays Count(Field B ) on Y axis on Change of Field A on X Axis.
Right now i am able to sort the chart based on Field B.

Is it possible to sort the chart based on Field C?
I want to display the order of the count, same order as the Field C
vvuppuluriAsked:
Who is Participating?
 
Dan WeingartAuthor / CRChartCommented:
If all else fails,  you could likely do this with our CRChart add-in.  Use the @SORT with value of 8 or 9 to key off the first series, then use @IS to hide the key series from showing up in the graph.

-Dan

DISCLAIMER: I work for the company, threedgraphics.com, that makes this product. This product costs money.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.