+ Reply to Thread
Results 1 to 4 of 4

Thread: x-axis problems

  1. 04-04-2010, 05:30 AM #1
    happyaslarry1
    happyaslarry1 is offline
    Registered User
    Join Date
    04-04-2010
    Location
    Henley, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    x-axis problems

    Hi all

    Newbie to creating charts in excel.

    Working out radiator prices in the attached spreadsheet. I'm having a problem with getting the x-axis to work correctly on the attached chart.

    The x-axis is a value scale rather than a category scale but I can't see how to get excel to plot it correctly. The series for the 300 high radiators should have x-axis marks at 400, 800, 1200mm etc but it is just treating it as value 1,2,3 etc... Also, can I force excel to start at zero on the x-axis and the x-acis is showing values of 160 instead of 1600 etc.

    Any help to correct these issues would be much appreciated.

    Many thanks,

    Larry
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 04-04-2010, 08:52 AM #2
    ratcat
    ratcat is offline
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    815

    Re: x-axis problems

    G'day Larry and welcome to the forum,

    I've modified your workbook. Basically as you explained "but it is just treating it as value 1,2,3 etc... " as I am a noob at charts as well I see it as the same thing so you must map the all data the same.

    Now has I have xl2007 and you have xl2003. I don't know the steps to found the following.

    "Hidden and Empty Cell Settings" (Found in the 'Select Data' menu box) Then the next step is to set the option format to hide 'hidden rows and columns" option and 'Connect data points with line".

    I hope this is not clear as mud, I'm happy for someone else with more xl2003 exp. to explain more.

    Cheers

    RC
    Attached Files Attached Files
    Have I made you happy ??? If yes, please make me happy by pressing the Reputation icon in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks


    I don't void confusion, I create it
    Reply With Quote Reply With Quote
  3. 04-04-2010, 09:11 PM #3
    teylyn
    teylyn is offline
    Forum Guru
    Join Date
    10-28-2008
    Location
    Not here anymore
    MS-Off Ver
    irrelevant
    Posts
    10,150

    Re: x-axis problems

    Alternative suggestion:

    Change the chart to an XY Chart and assign each data series its original length values from Column B. The XY chart will take care of the proper spacing automatically.

    Set the X axis to a minimum value of 300 and a maximum of 2100, and a major unit of 100.

    see attached.
    Attached Files Attached Files
    My MVP profile
    Reply With Quote Reply With Quote
  4. 04-04-2010, 09:59 PM #4
    ratcat
    ratcat is offline
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    815

    Re: x-axis problems

    Thanks Teylen for the insight
    Have I made you happy ??? If yes, please make me happy by pressing the Reputation icon in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks


    I don't void confusion, I create it
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0