+ Reply to Thread
Results 1 to 3 of 3

Multiple X-Axis Values

  1. #1
    Rob Herrmann
    Guest

    Multiple X-Axis Values

    I am trying to graph data where the scale for the x-axis has multiple
    values. For example the value 3 also represents 76.2 on the x axis. Is
    there a way to show multiple x axis values. Also can I make vertical
    lines at certain x values.

  2. #2
    Jon Peltier
    Guest

    Re: Multiple X-Axis Values

    Rob -

    1. I don't know what this means:

    "For example the value 3 also represents 76.2 on the x axis."

    Do you want a secondary X axis, or do you want a numerical axis where now you just
    have categories at arbitrary spacing?

    2. Here's how to make lines on a line chart:

    http://peltiertech.com/Excel/Charts/AddLine.html

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______

    Rob Herrmann wrote:

    > I am trying to graph data where the scale for the x-axis has multiple
    > values. For example the value 3 also represents 76.2 on the x axis. Is
    > there a way to show multiple x axis values. Also can I make vertical
    > lines at certain x values.



  3. #3
    Rob Herrmann
    Guest

    Re: Multiple X-Axis Values

    Jon,

    Thanks for the help. Your file actually showed me what I was looking
    for on both of my questions. What I was looking for was a secondary X
    axis that had spacing that matched the primary axis which has a
    logarithmic spacing.

    Rob

    Jon Peltier wrote:
    > Rob -
    >
    > 1. I don't know what this means:
    >
    > "For example the value 3 also represents 76.2 on the x axis."
    >
    > Do you want a secondary X axis, or do you want a numerical axis where
    > now you just have categories at arbitrary spacing?
    >
    > 2. Here's how to make lines on a line chart:
    >
    > http://peltiertech.com/Excel/Charts/AddLine.html
    >
    > - Jon
    > -------
    > Jon Peltier, Microsoft Excel MVP
    > Peltier Technical Services
    > Tutorials and Custom Solutions
    > http://PeltierTech.com/
    > _______
    >
    > Rob Herrmann wrote:
    >
    >> I am trying to graph data where the scale for the x-axis has multiple
    >> values. For example the value 3 also represents 76.2 on the x axis.
    >> Is there a way to show multiple x axis values. Also can I make
    >> vertical lines at certain x values.

    >
    >


+ 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