+ Reply to Thread
Results 1 to 2 of 2

How do I build a volume area chart?

  1. #1
    Registered User
    Join Date
    08-29-2020
    Location
    Christchurch
    MS-Off Ver
    Office 365
    Posts
    1

    Question How do I build a volume area chart?

    Thanks for the feedback AliGW!

    Hi Everyone!

    Thank you for taking the time to read this post. I need to report on the following:

    1. I have to plot the effect that some projects would have on the CO2 emissions of a company over 10 years
    2. The organization has an ongoing and increasing CO2 emissions level which is measurable and predictable.
    3. For simplicity sake let us say that I have 3 projects of variable length that all have a predictable impact on the overall CO2 emissions for the organization year to year. ( sorry i cant upload an image - The option to add the image once selected isnt there (Edge and Chrome). The Project values are reductions in the CO2 emissions.

    Year Baseline Project 1 Project 2 Project 3
    FY18 157,149
    FY19 169,000
    FY20 175,000
    FY21 180,000 11,000
    FY22 185,000 35,000 31,850
    FY23 190,000 35,000 31,850 888
    FY24 195,000 35,000 31,850 888
    FY25 200,000 35,000 31,850 888
    FY26 205,000 35,000 31,850 888
    FY27 210,000 35,000 31,850 888
    FY28 215,000 35,000 31,850 888

    Project 1 starts in financial year 2021, project 2 in 2022 and Project 3 in 2023 in the above example

    What I am looking to produce is a graph that shows the CO2 emissions levels increase over time (Baseline) BUT incorporates the impact that each project will have on reducing that level over time. I thought a volume area chart would may be a good display but do not know how to create one. Could someone give me some guidance on how I could use this data to construct the graph i am looking for? It would also be fantastic if the graph allowed for projects to be selected or deselected and the visual update to show the impact of adding or removing those projects to the overall levels.

    I wish I could post a picture as it would undoubtedly be easier to show what I would like to achieve.

    Much obliged to you for the time to read this and I hope someone out there who knows Excel well can give me a guide on how I should/could structure some tables and enable a graph from that data!

    Stay safe - Be well and thank you kindly!
    Krys
    Last edited by KrysRuadan; 08-29-2020 at 11:19 PM. Reason: Admin request

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    42,017

    Re: Guidance on what should be a simple(ish) chart?

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, specifically.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. I would normally do this for you, as you are new, but I do not fully understand what you are trying to show, so you will need to do it yourself. Sorry.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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. Guidance implementing chart
    By ritmo2k in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-04-2018, 02:24 PM
  2. Simple (?) chart prob--Needing a simple solution!
    By baloo308 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-06-2016, 12:24 PM
  3. Interactive Column Chart - need guidance
    By ankur01 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-19-2013, 09:28 AM
  4. simple chart
    By rockville9 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-14-2013, 12:53 AM
  5. Simple X-Y chart
    By djchapple in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-07-2007, 03:40 PM
  6. [SOLVED] A simple chart..
    By Freddie Mac in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-01-2006, 09:30 PM
  7. [SOLVED] Simple chart
    By TomC in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-04-2005, 09:06 PM

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