Results 1 to 3 of 3

I want data row information on X axis

Threaded View

  1. #1
    Registered User
    Join Date
    08-23-2011
    Location
    Toronto,Ontario
    MS-Off Ver
    Excel 2003
    Posts
    48

    I want data row information on X axis

    I have a simple line chart. The X axis is a row of numbers and the Y axis is a second row of numbers. However, the chart puts in the Y axis values but only breaks down the X axis into 12 subdivisions numbered 1 to 12 instead of using my data information on the X axis for easy viewing.

    Also, the intersection points aren't on the major grid lines. I can't see anything in the chart wizard setup to input my data for the X axis and get the proper intersection points.

    I am adding a screenshot and the file for viewing.

    Danny
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by HitTheEXCELerator; 09-07-2011 at 09:43 PM.

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