+ Reply to Thread
Results 1 to 2 of 2

Basic Line Chart Setup with Multiple Lines Grouped by Month

  1. #1
    Registered User
    Join Date
    09-30-2022
    Location
    Indiana, United States
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    12

    Basic Line Chart Setup with Multiple Lines Grouped by Month

    Looking for help on how I would setup a chart that has a layout like the horrible computer sketched picture I have attached. I would only Chart one Metric at a time from column A
    QIN graph.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,913

    Re: Basic Line Chart Setup with Multiple Lines Grouped by Month

    I find that many charting questions really end up being spreadsheet questions -- such as your case. Currently, the data are very poorly arranged in the spreadsheet to give the kind of chart you show in your picture. By far the easiest way to achieve the chart you want will be to rearrange the data in the spreadsheet. Once you get the data properly arranged in the spreadsheet, creating the chart should be straightforward (see this essay for a detailed explanation: https://peltiertech.com/good-chart-data/ ).

    Rearranging the data probably needs to begin by understanding if this is the raw data or if this is a summary of a broader database of data. If this is the raw data, there could be value in considering some kind of "unpivot" operation to make a good database that will make future manipulations a lot easier. If this is a summary of a broader database, then it might be easier to start with the database query and make changes there to get a better arrangement.

    So, without getting into specifics, yet, what can you tell us about where this data comes from, how it gets into this spreadsheet, and what changes you are allowed to make to how the data is arranged in the sheet?
    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. [SOLVED] One line of Data duplicated into multiple lines changing values of some lines
    By benjy99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2020, 12:20 PM
  2. Replies: 4
    Last Post: 09-19-2019, 10:54 AM
  3. Replies: 4
    Last Post: 08-27-2019, 02:40 PM
  4. Excel chart grouped by month and week
    By mvparker79 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-13-2016, 01:04 PM
  5. Difficulty creating a basic line chart without breaks in line plots
    By brharrii in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 04-05-2013, 04:29 PM
  6. Replies: 2
    Last Post: 11-14-2012, 08:59 AM
  7. [SOLVED] Plotting multiple lines in Line Chart that have a very broad scale
    By NewTothisStuff in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-14-2012, 11:09 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