Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Chart x-axis sort vs. what to display in the label

Status
Not open for further replies.

PatchesPete

Technical User
Jun 30, 2009
14
US
I want to create a line chart that shows an employee's sales percentage. It should be sorted by the percentage descending. Problem I am having is I don't want the percentage to show in the x-axis, just the employee's name, in the order of the sales percentage highest to lowest. I attached a very basic sample. On the x-axis I want Employee C, Employee F, Employee B not 89.67, 73.38, 72.73. Is there a way to do that? If I were to start with the percentage first, I could use a formula for the sort and display the percent and the name, but since I only want the Employee name, I'm not sure how to do that. Using Crystal Reports 2011, version 14. Thanks.
 
 http://files.engineering.com/getfile.aspx?folder=2af86803-1ae2-4038-88ac-818ab2a56e2c&file=SampleChart.gif
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top