+ Reply to Thread
Results 1 to 2 of 2

Graph comparing against average and median

  1. #1
    Registered User
    Join Date
    10-14-2015
    Location
    NY, USA
    MS-Off Ver
    2007
    Posts
    46

    Graph comparing against average and median

    Hi,

    I have three sets of data showing how Company X is performing against industry avg and median. I would like to translate that into a graph. Which graph is the best. Please follow me through the steps thanks

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Graph comparing against average and median

    I selected your data and copied it and pasted TRANSPOSED so that the years are down the column and the values are in the rows. I also changed your mix of % and numbers to all numbers because the chart was grossly distorted and didn't show much. I chose a Scatter chart and on the Y axis I changed the Minimum to fixed at 400 and the Maximum fixed at 600.

    I think that this will result in something understandable.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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] Count IF Average, Median , SD and Range
    By Matt1998 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2014, 11:51 AM
  2. Replies: 2
    Last Post: 04-06-2014, 02:26 AM
  3. [SOLVED] Average & Median
    By lstevenson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-27-2014, 02:20 AM
  4. Average and Median by week and month from daily data
    By jjj444 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2013, 11:01 PM
  5. Average, Median Max and Min of a Specific Range
    By PraveshG81 in forum Excel General
    Replies: 2
    Last Post: 05-10-2012, 08:14 PM
  6. Adding median lines to xy scatter graph
    By Richard Buttrey in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 12-08-2010, 09:05 PM
  7. pivot: average vs. median
    By dave in Toronto in forum Excel General
    Replies: 2
    Last Post: 09-08-2005, 10:05 AM

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