+ 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

  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:

    Please Login or Register  to view this content.
    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
    Rocester, New York, USA
    MS-Off Ver
    Excel 2007:10
    Posts
    2,019

    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