+ Reply to Thread
Results 1 to 2 of 2

Plot on axis a different range than that one used for graph

  1. #1
    Forum Contributor
    Join Date
    07-22-2012
    Location
    Spain
    MS-Off Ver
    Excel 2008
    Posts
    304

    Plot on axis a different range than that one used for graph

    Hi,

    Is it possible to show on the x-axis from a chart different values than that ones used for plotting the chart?
    I have attached an example for explaining myself better.

    Any help would be much appreciated.

    Kind regards,
    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,814

    Re: Plot on axis a different range than that one used for graph

    I would recommend a variation of this "vertical category axis" technique: http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

    The basic idea would be:
    1) Create a second series. The X-values for this series should be locations along the x axis where you want the "trip number" labels to appear. The y-values should be 0, if you want these labels along the x axis, or some other suitable value, depending on where you would like the labels to show up. Include a column with the desired trip number for each point
    2) Add this series to the scatter chart.
    3) Using Rob Bovey's XY Chart labeler add-in (appspro.com), label this new series with the desired trip labels.
    4) Format the 2nd series as desired (you could even format as no marker no line if you want it to be invisible except for the labels).
    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. [SOLVED] Plot two series ordered by different dates in the same graph, on the same x-axis.
    By droppe in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-14-2013, 07:14 AM
  2. [SOLVED] Dynamic Graph, Do Not Want X-Axis to Plot Blank or Zero Values
    By TEBrown in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 04-11-2013, 05:08 AM
  3. Replies: 1
    Last Post: 10-08-2012, 05:04 AM
  4. How to plot scatter graph on horizontal axis
    By alsupport in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-28-2010, 04:53 AM
  5. Plot 2 data lines, same graph, same axis
    By Simoncush in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-24-2010, 05:03 AM

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