+ Reply to Thread
Results 1 to 3 of 3

Best Chart for mix of positives and negatives

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    8

    Best Chart for mix of positives and negatives

    I'm looking to create a chart that'll effectively show the overall loss of a company and all the pieces that make it up. Let's say the overall loss is $1,000. There are 8 plants that make up up the overall company. 5 with profit, 3 with a loss. It's tough to find a chart to effectively display negs and positives. Pies seem like a definite no even-though I am trying to depict the "pieces of the whole relationship." Any suggestions out there? Below are number to play with.

    Plant 1 $200
    Plant 2 $200
    Plant 3 $200
    Plant 4 $100
    Plant 5 $100
    Plant 6 $-700
    Plant 7 $-600
    Plant 8 $-500

    Total $-1,000

  2. #2
    Forum Contributor
    Join Date
    01-02-2007
    Location
    Australia NSW
    MS-Off Ver
    2013
    Posts
    494

    Re: Best Chart for mix of positives and negatives

    Most charts apart from pie can be set to display negative values.
    It is an option in the axis settings from memory.

  3. #3
    Registered User
    Join Date
    01-08-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Best Chart for mix of positives and negatives

    Hello,
    I have provided 2 different charts(line and bar) , let me know if you need anything else.
    Thanks
    Harini.S
    Attached Files Attached Files

+ 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