sorting in a chart

R

Rob

I made a chart where the bottom axis is the month. Im
having trouble keeping it in chronological order. I want
it listed as "Jan, Feb," etc. but it places them in
alphabetical order. Can I get it to order by a seperate
numeric month field or do I need to use the numeric field
as the axis and change it to text somehow?
 
D

Duane Hookom

The sorting is based on the sorting in the Row Source query. Sort this query
by Month([DateField]) and the chart will be sorted.
 

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

Similar Threads

Outlook Web - Sorting Calendars by Alphabetical order? 0
Doughnut Chart linked with the slicer in the pivot table 0
Create a chart from a table in word thats dynamic 0
Reversing Dates Sequence along X axis in a chart 3
Chart help - Y Axis question 1
Save a custom chart as a template 0
Sorting Month-Year in Query 7
Chart 1

Top