+ Reply to Thread
Results 1 to 6 of 6

Chart to compare Products broken down by Cost and Year

  1. #1
    Registered User
    Join Date
    10-16-2011
    Location
    Chippenham, UK
    MS-Off Ver
    Excel 2003/2007
    Posts
    14

    Chart to compare Products broken down by Cost and Year

    Hi guys, it's been a while since I was last here.

    Is it possible to chart various products by cost and then compare them against each other? I've attached a file which I hope explains it a little better.

    TIA
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111

    Re: Chart to compare Products broken down by Cost and Year

    G'day,

    Do you mean like this ? Andy Pope's Stackside Chart
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Chart to compare Products broken down by Cost and Year

    This is all down to data layout.

    Two new charts in the attached. Hopefully one of them is what you mean.

    BSB
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-16-2011
    Location
    Chippenham, UK
    MS-Off Ver
    Excel 2003/2007
    Posts
    14

    Re: Chart to compare Products broken down by Cost and Year

    Thanks Ratcat, your example sheet has given me some ideas on how to complete this task.

  5. #5
    Registered User
    Join Date
    10-16-2011
    Location
    Chippenham, UK
    MS-Off Ver
    Excel 2003/2007
    Posts
    14

    Re: Chart to compare Products broken down by Cost and Year

    Thanks BadlySpelledBuoy, you've helped me consolidate my thoughts. I knew I needed to change how the data was formatted I just couldn't figure out how.

  6. #6
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Chart to compare Products broken down by Cost and Year

    Happy to help.

    BSB

+ 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] Calculate Cost of Products Based On Multiple Criteria
    By DomLeRoy in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-09-2017, 05:26 AM
  2. Chart to compare bi weekly amount, this year vs last year
    By sleepyjim in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-31-2016, 05:57 AM
  3. formula to output upcoming quarter end date (for a broken fiscal year)
    By canaille in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-22-2014, 05:01 PM
  4. Auto-calculating spend broken across year by dates
    By Scott_Hall in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-07-2013, 11:16 AM
  5. Compare products on 2 sheets
    By ..Sam.. in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-13-2009, 11:48 PM
  6. formula - calculate the yearly cost each year of the 10 year contract
    By Ineedxhelp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2008, 11:23 PM
  7. How to compare current year to prior year in bar chart?
    By substring in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-12-2005, 02:06 PM

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