Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I get monthly data in the data area to remain in order
The data area is rearranging the months in alphabetical order. How can I
change this? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I get monthly data in the data area to remain in order
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. -- John Mansfield "LauraFitzroy" wrote: The data area is rearranging the months in alphabetical order. How can I change this? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I get monthly data in the data area to remain in order
Thanks John!! It worked. Also, before receiving yr reply, I tried
protecting the sheet of original data, which worked as well. Thanks again "John Mansfield" wrote: 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. -- John Mansfield "LauraFitzroy" wrote: The data area is rearranging the months in alphabetical order. How can I change this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert monthly data into quarterly data? | Excel Discussion (Misc queries) | |||
How to edit column data so that all but left most character remain | Excel Discussion (Misc queries) | |||
Can formulas in cells be made to remain if the data is deleted? | New Users to Excel | |||
data source remain constant | Charts and Charting in Excel | |||
How do I convert monthly data to quarterly data? | Excel Discussion (Misc queries) |