Pie Chart by Day of Week

[Charliy]

I should know this but I'm brain dead this morning.

I want a pie chart that breaks out the data by day of week, and I want it to show the name of the day (Sun, Mon, etc.) while staying in the correct order. I have formulas for the numberic day of week and the alpha day of week. I was hoping the chart had a feature like crosstabs where you can sort by one field and use a formula for the heading, but haven't found anything like that.

Using Crystal XI

 

[pmax9999]

Hi Charliy

The only way I have found to achieve this is by sorting in specified order.

I would love to know of a better way if you find one.

Cheers
Pete

 

[Charliy]

What I've been doing is essentially adding a secondary legend to the chart that says "1=Sunday, 2=Monday. . .