+ Reply to Thread
Results 1 to 2 of 2

PivotChart Question

  1. #1
    Registered User
    Join Date
    03-14-2008
    Posts
    20

    PivotChart Question

    When I created my PivotChart from my database the "Month" category shows up but the months are not in order. It's in "Feb, March, Jan" and I would like it in chronological order.

    This is how my database is set up

    Year/Month/Department/Type etc...
    2008/January/Heating/
    2008/February/Heating/
    2008/March/Heating
    2008/January/Cooling
    2008/February/Cooling
    2008/March/Cooling
    etc....


    I only have data entered for Jan-March. How do I change the list so it's in chronological order?

    Thank you!

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075
    Double click on the Month button, then click on Options to find the available sort options.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1