+ Reply to Thread
Results 1 to 3 of 3

Excel inverted line graph, not switch row / column

  1. #1
    Registered User
    Join Date
    12-08-2016
    Location
    Johannesburg
    MS-Off Ver
    365
    Posts
    1

    Excel inverted line graph, not switch row / column

    I am plotting a line graph where the X axis labels are long statements, each associated with a value in the Y axis. The usual line graph in Excel plots this with the X axis labels at the bottom, and reading is difficult in this way. I want to still have a line graph but with the X axis displayed vertically on the left and the Y axis numbers horizontally, but not in the way that switch row / column works. The attached graph (Excel line graph.png) shows how Excel normally plots this, quite normal. The second attachment is how I really want it plotted (this one was done in Highcharts) in Excel. Is there anyone that knows how to do this?

    All help appreciated

    V
    Attached Images Attached Images

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: Excel inverted line graph, not switch row / column

    Use switch row/column, then click on the vertical axis and check the box labeled "Values in reverse order".

    If that is not quite what you are looking for please attach your file instead of an image.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,814

    Re: Excel inverted line graph, not switch row / column

    Using this tutorial to create a "dot plot" will turn a line chart on its side: http://peltiertech.com/Excel/Charts/DotPlot.html
    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. Combine Line Graph & Stacked Column Graph
    By CGreenie in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-07-2015, 12:09 PM
  2. switch row/column graph vba
    By SpaceRocksMars in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2014, 02:12 PM
  3. [SOLVED] Graphing a column graph within a line graph
    By NeoFlex in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-16-2013, 08:23 AM
  4. Add secondary column graph to existing line graph
    By nbuk in forum Excel General
    Replies: 8
    Last Post: 09-02-2010, 11:49 AM
  5. How to combine one segmented column graph with line graph in one chart
    By hamood83 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-26-2007, 03:19 AM
  6. What is the command-line print switch in Excel?
    By eeidfn in forum Excel General
    Replies: 5
    Last Post: 02-17-2006, 08:10 PM
  7. Graph on Inverted Scale
    By Deepak Thakkar in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-26-2005, 03:04 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