+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Stacked charts

  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Stacked charts

    Hi - I'm new to this forum and apologize if this has already been asked and answered several times. I'm trying to create a stacked chart, but with both values starting at zero, if that makes sense. A good example would be if something costs $5 and an upgrade to it is $7, for a total of $12. In this example, I'd have two lines - the first 'base price' and the second 'total price' of $5 and $12, respectively. In a typical stacked chart, that turns out $5 with $12 on top of it....is there a way to have the $12 start at zero as well so the base would be seen as $5 and the upgrade as $7? I suppose you could just do the formula and chart the difference, but it seems like there should be an easy way to do that...

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Stacked charts

    Hello,

    I'm afraid I'm not following. If something is $5 and the price is raised to $7, then the price is $7, not $12.

    Can you upload a workbook with some sample data, a sample chart, and explain in context?

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Stacked charts

    Is this what you mean?
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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