+ Reply to Thread
Results 1 to 2 of 2

Line Chart - Horizontal is months, vertical is lables and totals

  1. #1
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    179

    Line Chart - Horizontal is months, vertical is lables and totals

    Hello,

    I am having issues getting this line chart to line up the way I want it (attached excel).

    I want to grab the months of Jul-20 to Dec -20 in row 3 of sheet1, and display that up top as horizontal.

    Then grab A7:A9 vertical lables from sheet1. And also grab G7:M9 for data to display across horizontal.

    any ideas?

    chart.PNG

    Chart Data.PNG
    Attached Files Attached Files

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

    Re: Line Chart - Horizontal is months, vertical is lables and totals

    I wasn't sure of all the details, but this should be close:

    1) I selected A7:A9 -> Ctrl -> select G7:M9 to get a multi-area selection
    2) Insert -> Line chart. Excel defaults to count numbers on the horizontal axis, A7:A9 as the series names/labels, and each row in G7:M9 as the values it charts for each series.
    3) To get the dates on the horizontal axis, I pull up the select data dialog -> Edit horizontal category axis labels -> Tell it to use G3:M3 (which technically corresponds to Jun to Dec rather than Jul to Dec. I wasn't sure which one you intended).

    That should be close to what you describe.
    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. Replies: 2
    Last Post: 06-28-2019, 03:35 AM
  2. Replies: 6
    Last Post: 11-03-2018, 04:50 AM
  3. Add vertical / horizontal line to chart created with VBA
    By pp57 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2017, 04:17 PM
  4. [SOLVED] How to add a vertical line graph on a stacked horizontal bar chart?
    By Why123 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-14-2015, 07:20 PM
  5. Have horizontal bars--want to indicate average with vertical line....
    By sarahsez in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-10-2012, 04:51 AM
  6. Convert Horizontal Line Items to Vertical?
    By evo420 in forum Excel General
    Replies: 1
    Last Post: 01-26-2011, 06:51 PM
  7. Manually add fixed vertical horizontal line to chart
    By datacruncher in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-21-2009, 08:33 AM

Tags for this Thread

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