Results 1 to 4 of 4

THIS IS PROBABLY SUPER EASY...Excel Line Graph X-axis scaling!!!

Threaded View

  1. 06-01-2014, 03:35 PM #1
    aillc825
    aillc825 is offline
    Registered User
    Join Date
    05-29-2014
    Posts
    5

    THIS IS PROBABLY SUPER EASY...Excel Line Graph X-axis scaling!!!

    There are 20 years on the x-axis of a line graph. I want the scale for the first 9 years to be 1 (So year 1,2,3,...etc), and then 10-20 to be 2 (so 12, 14,16,18..etc). How do I do that?

    Also, how to find the intersection point between the two lines on line graph and show its corresponding year?
    Attached Files Attached Files
    Last edited by aillc825; 06-01-2014 at 04:56 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Scaling on horizontal axis is irregular, leads to improper line graph
    By Al Lagasse in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-16-2013, 04:03 PM
  2. Excel 2007 Graph Axis Scaling question
    By controlfreak in forum Excel General
    Replies: 2
    Last Post: 04-25-2011, 06:40 AM
  3. scaling x axis for Bar Graph
    By Innov8ive in forum Excel General
    Replies: 3
    Last Post: 04-14-2010, 10:55 AM
  4. [SOLVED] Scaling time on the x-axis of a graph
    By Callum in forum Excel General
    Replies: 1
    Last Post: 05-19-2006, 09:10 PM
  5. X-Axis scaling on graph
    By bob2 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-20-2005, 12:12 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1