+ Reply to Thread
Results 1 to 4 of 4

Trying to generate a specific type of graph

  1. #1
    Registered User
    Join Date
    08-07-2022
    Location
    Louisiana, USA
    MS-Off Ver
    365
    Posts
    8

    Trying to generate a specific type of graph

    I would like an area graph generated in excel but I can't figure out how to format it like the image attached. If you have any recommendations, it would be greatly appreciated.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by helpmeexcelexperts; 03-19-2023 at 06:30 PM.

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

    Re: Trying to generate a specific type of graph

    A find sometimes that most of a charting question is really about arranging the data in the spreadsheet. Here's a good tutorial on what "good" chart data looks like: https://peltiertech.com/good-chart-data/ I think you will find that, if you can arrange the data (or arrange a copy of the data) into something like Peltier describes, you will have no difficulty creating a stacked area chart. In your case, I would expect:
    1) Put the years in a single column at the left of the table the chart will use
    2) Enter the topic names in the top row of the table the chart will use.
    3) The record values can then fit into the body of the table the chart will use.
    4) You should then be able to select this table, insert an area chart, and the chart should nearly create itself.
    5) Format chart elements as desired.

    The first question for you is whether you are required to build the chart from the table you show in your sample file, or if you would be allowed to rearrange the data (or rearrange a copy of the data)?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,919

    Re: Trying to generate a specific type of graph

    This looks like a stacked area chart.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  4. #4
    Registered User
    Join Date
    08-07-2022
    Location
    Louisiana, USA
    MS-Off Ver
    365
    Posts
    8

    Re: Trying to generate a specific type of graph

    Thank you! That helped!

+ 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. Unable to Plot Graph correctly (Possibly just a Graph Type Issue)
    By BernieLee02 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-29-2019, 12:45 PM
  2. How to Generate a Graph in Excel
    By nedyarb in forum Excel General
    Replies: 4
    Last Post: 07-29-2018, 11:13 AM
  3. Can Excel generate this type of text report?
    By ophlyne in forum Excel General
    Replies: 1
    Last Post: 05-04-2017, 01:40 AM
  4. [SOLVED] Making a specific type of graph design.
    By damp in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-07-2014, 06:52 AM
  5. i need to generate graph from the combobox
    By ginger426 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-11-2013, 05:36 AM
  6. [SOLVED] Macro to generate a random number between 2 specific values into specific cells.
    By Nerfmagnet in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-10-2013, 11:45 AM
  7. Replies: 3
    Last Post: 09-14-2012, 11:59 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