+ Reply to Thread
Results 1 to 2 of 2

How to plot a line chart with y-axis (text) on left and x-axis (percentage)on top of chart

Hybrid View

  1. #1
    Registered User
    Join Date
    11-20-2015
    Location
    New Hampshire
    MS-Off Ver
    2013
    Posts
    1

    How to plot a line chart with y-axis (text) on left and x-axis (percentage)on top of chart

    I am trying to create a line chart that has categories on the y-axis and percentages on the x-axis. The y-axis must be on the left and the x-axis on the top.

    My data table looks like the below:

    	Past	Present	Future
    Red	10%	25%	50%
    Blue	15%	35%	75%
    Green	15%	50%	90%
    Yellow	20%	50%	80%
    In essence the chart would plot the lines vertically down from the top.

    Any idea how this could be done?
    Last edited by 6StringJazzer; 11-20-2015 at 12:17 PM. Reason: added code tags for spacing

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: How to plot a line chart with y-axis (text) on left and x-axis (percentage)on top of c

    I think you want a Bar Chart (not a Column chart), with the Vertical (Category) Axis: "Format Selection": "Axis Options": "Categories in reverse order" box checked.

    If I'm understanding your request correctly, that should get where you want to be.

    See attached.
    Attached Files Attached Files
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

+ 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: 3
    Last Post: 04-30-2014, 05:57 AM
  2. Replies: 2
    Last Post: 02-07-2014, 12:18 PM
  3. Replies: 2
    Last Post: 06-19-2012, 06:50 PM
  4. Line Chart Y-Axis is subdivided into discrete ranges same x-axis
    By texaschili in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-01-2010, 06:31 PM
  5. Can you plot text on a chart? And what if I don't want a y-axis?
    By mm511 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-02-2007, 06:35 AM
  6. [SOLVED] How to plot chart with 2 different y-axis with a common x-axis?
    By ARC in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-15-2006, 04:45 AM
  7. Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis
    By mw210461@yahoo.com in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-13-2005, 05:05 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