+ Reply to Thread
Results 1 to 2 of 2

need a chart showing what has increase and decreased.

  1. #1
    Registered User
    Join Date
    06-30-2010
    Location
    Newport New VA
    MS-Off Ver
    Excel 2003
    Posts
    97

    need a chart showing what has increase and decreased.

    so basically i have a set of data that shows some locations have increased msos' while others have increased. What I would like to see is maybe a demarcation in the middle of the chart that shows 100% then those that have increased the chart would show them above that, while those that decreased will show below thait.. here is the data set.

    I WAS TRYING TO USE A BUBBLE CHART, WHERE EACH LOCATION WOULD HAVE A BOUBLE AND THE BOUBLE WOULD SHOW BELOW OR ABOVE THE 100 LINE. AND SPREAD OUT.




    SOMETHING LIKE THIS

    O
    O
    ----------------O------ 100
    O
    O

    HERE IS THE DATA. ANY SUGGESTIONS?


    August August
    MSO's MSO's
    2012 2013
    ALL 130 175 134.615%
    vb 29 30 103.448%
    IL 30 57 190.000%
    CA 15 18 120.000%
    NJ 28 47 167.857%
    PR 4 3 75.000%
    TX 24 20 83.333%

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

    Re: need a chart showing what has increase and decreased.

    You can show the values as percentages using a line chart with just markers.
    Or you can show the data as a difference and use either line or column chart
    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)

Similar Threads

  1. Showing the increase in the value of a cell
    By gally in forum Excel General
    Replies: 2
    Last Post: 10-28-2012, 06:52 PM
  2. Replies: 1
    Last Post: 07-14-2012, 11:46 AM
  3. graphing a chart in VBA, showing series legends on the chart
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-05-2012, 07:12 AM
  4. [SOLVED] Increase a value by a % with result showing in original cell?
    By ASmith in forum Excel General
    Replies: 1
    Last Post: 08-07-2006, 04:55 PM
  5. Finding decreased value PLEASE HELP ASAP!
    By grimschris in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-15-2005, 04: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