Results 1 to 4 of 4

Help with Plotting data Axis Category labels

Threaded View

  1. #1
    Registered User
    Join Date
    02-24-2012
    Location
    Kansas City
    MS-Off Ver
    Excel 2010
    Posts
    13

    Help with Plotting data Axis Category labels

    It has been a while since I have created column graphs in Excel (used old 2007). I am working in 2010 and have the following data:

    DATE AMOUNT CUMULATIVE LEVEL OF DEBT
    Aug-05 28,500,000 28,500,000
    Aug-06 80,000,000 108,500,000
    Sep-06 80,000,000 188,500,000
    Mar-07 150,000,000 338,500,000
    Mar-07 150,000,000 488,500,000
    Sep-07 150,000,000 558,500,000
    Sep-07 150,000,000 708,500,000
    Mar-08 50,000,000 758,500,000
    Mar-08 52,500,000 811,000,000
    4,000,000 815,000,000
    10,000,000 825,000,000
    7,500,000 832,500,000
    9,000,000 841,500,000
    45,000,000 886,500,000

    When I try to chart the data, the Vertical Value Axis only displays Jan-00 throughout, and my Horizontal Category Axis displays 1-14. In 2007 Excel, it was easier to change the labels. I have attached a PDF for your review of result from the data.

    Any help would be greatly appreciated!
    Attached Files Attached Files

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