Pivotchart axix sort

S

swas

Hi,
I am trying to get me head around pivotcharts, which strike me as really
versatile but very restricted help available.

I am displaying workload for employees over the next 2 weeks. I want the
catergory axix (Which is the date) to be readable for the user such as Mon
12/10 or 12/10 Mon.

I can format the text no worries, but because the axis sorts on this text I
can't get the axis in the correct date order! If I keep is as a full date I
can get by, but makes the graph very cluttered.

Surely there is a way to display axis tags yet sort on a different field?

Also, any good links or books for pivotcharts is appreciated.


swas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top