+ Reply to Thread
Results 1 to 5 of 5

Single axis graph/chart

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    Colorado
    MS-Off Ver
    Excel 2007
    Posts
    19

    Single axis graph/chart

    Hi All,

    Not sure if this is even possible, but does anyone know how to make a chart that only reflects one axis of data (i.e. x-axis only)? The issue is that I want to create a graph that shows a series of percentages as points on an x-axis, but I don't want a y-axis. If this is somehow possible, would anyone know how to then shade that axis, so that one end is green and slowly changes to red on the other end?

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Single axis graph/chart

    Try setting Y to zero for all values and then editing the scatter plot so that the Y axis is not visible (Axes on the Layout ribbon)
    Martin

  3. #3
    Registered User
    Join Date
    07-29-2013
    Location
    Colorado
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Single axis graph/chart

    Awesome, that worked. Do you by chance know how to create a color shading on the axis?

  4. #4
    Registered User
    Join Date
    05-31-2013
    Location
    Georgia, USA
    MS-Off Ver
    Office 2010 Enterprise
    Posts
    10

    Re: Single axis graph/chart

    Did you try using a gradient fill on the plot area?
    Capture.JPG

  5. #5
    Registered User
    Join Date
    07-29-2013
    Location
    Colorado
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Single axis graph/chart

    I did not even think about the plot area because I was so focused on the axis, but I believe this should work. Thank you!

+ 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] 3 axis chart with stacked bar graph and line graph above
    By hefe_espada in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-26-2013, 12:53 PM
  2. Replies: 1
    Last Post: 12-10-2012, 11:15 AM
  3. Single chart - dual axis
    By Vigs20 in forum Excel General
    Replies: 8
    Last Post: 03-29-2011, 10:29 PM
  4. Replies: 5
    Last Post: 01-20-2011, 05:41 AM
  5. [SOLVED] Can I insert multiple scales on the Y axis of a single XY graph?
    By Saba Demian in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-10-2005, 06:06 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