+ Reply to Thread
Results 1 to 2 of 2

Need X-axis to show a set of numbers

  1. #1
    Registered User
    Join Date
    08-18-2009
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    96

    Need X-axis to show a set of numbers

    Attached is a graph I'm working on. I'm happy with the margin curve trend line on the secondary axis (I hid the main line and data. I like the smoothed line more). The price curve is doing what I want.

    What I can't seem to get right, is the cost to be listed at the bottom of the graph in the chart axis. I've tried inserting line chart and an X-Y chart (using 1 as the y-intercept). No luck

    Any thoughts on how to get an x-Axis to display the cost column to the left in the data set? It should read $0.10 to $1,000.00.

    Thanks much,

    Roger!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Need X-axis to show a set of numbers

    I'm not sure I understood. The main thing I noticed was that you are not using any range for the horizontal category x axis data, so Excel is using 1,2,3,.... The big first step in getting Excel to show the data in column A as the X axis data is to point the horizontal category x axis data to A2:A180. I tend to use the Select Data dialog for this.

    Your costs in column A are not evenly spaced, so I would expect to prefer a scatter chart over a line chart for this, but you can decide which one you want.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 06-22-2017, 06:16 PM
  2. Replies: 4
    Last Post: 07-31-2015, 12:54 AM
  3. [SOLVED] Need graph to show alphanumeric values as Y axis labels with Date as Z axis labels
    By Ochimus in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-24-2015, 08:40 PM
  4. Replies: 2
    Last Post: 03-17-2014, 07:58 AM
  5. [SOLVED] How can i change axis to show words instead of numbers as values
    By AnniC in forum Excel General
    Replies: 10
    Last Post: 03-06-2014, 09:54 AM
  6. Replies: 1
    Last Post: 12-19-2005, 04:25 PM
  7. Replies: 0
    Last Post: 12-19-2005, 02:40 PM

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