How do I get monthly data in the data area to remain in order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The data area is rearranging the months in alphabetical order. How can I
change this?
 
It sounds like your months might be entered as text. Try entering the months
as dates and then formatting them in the "Format Cells" dialog box. For
example, enter:

01/01/2007
02/01/2007
03/01/2007

Then go to the Format Cells dialog box and reformat the dates as you want
them to look.
 
Thanks John!! It worked. Also, before receiving yr reply, I tried
protecting the sheet of original data, which worked as well.

Thanks again
 
You must log in or register to reply here.

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

Do not sort data alphabetically in a Pivot table 1
Display order of Bar Chart 2
Changing a charts series order 1
Charts - Setting Data Area as a Variable 1
Help, please: sorting the Legend 2
How to chart months by financial year 0
Rearrange data into other columns 9
Chart moves on plot area when adding a third month 2

Back
Top