+ Reply to Thread
Results 1 to 3 of 3

How can I create a "hill" type chart in Excel?

  1. #1
    Registered User
    Join Date
    11-13-2015
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    19

    How can I create a "hill" type chart in Excel?

    I would like to produce a chart that shows the median salary for a position. I want it to resemble a hill in which the median salary is at the top of the hill and the higher and lower salaries are at the left and right bottoms of the hill. How can I go about doing this?

    Some example data would look like this:

    # of total positions @ salary salary amount
    5 50,000
    10 75,000
    50 100,000
    10 125,000
    5 150,000

    Thanks!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,541

    Re: How can I create a "hill" type chart in Excel?

    It seems so simple that I am uncertain if I am understanding this correctly. Have you tried to create a chart? What went right? What went wrong?

    If I assume that you intend to have "salary" across the horizontal axis and "# of positions" on the vertical axis:

    1) Select data
    2) Insert chart -> Line chart -> regular line chart (XY scatter might also work, and may be more appropriate for some data)
    3) Excel will have almost certainly guessed wrong in assigning ranges to the X and Y axes, so bring up the Select Data dialog. (Chart Tools -> Design -> Select Data)
    3a) Click "Edit" for the horizontal category axis labels, and make sure that it is using the Salary column
    3b) Select the first "Legend Series" entry and click "Edit". Make sure this is pointing to the "# of positions" data.
    3c) Remove any extra "legend series".
    4) Format chart elements as need.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2504
    Posts
    19,415

    Re: How can I create a "hill" type chart in Excel?

    You might also want to let Excel make you a pivot chart. Select your data and headers and insert a pivot table. In the field list box (which you'll see when you enable editing in the attached file) pull the amount to the row labels window and the # of positions to the values window. Select any cell in the pivot table and then select pivot chart, I used the Area chart type. Here is a file that used your data from post #1:
    Frequency Distribution Pivot Chart.xlsx
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Trying to create a "Gantt Chart" in Excel
    By bradenkeith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2016, 03:54 PM
  2. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  3. Create a Command Button to "Save As" and "Close" an Excel Workbook
    By thedunna in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-26-2013, 05:38 PM
  4. Replies: 3
    Last Post: 02-02-2013, 11:34 AM
  5. Excel 2010 (Run-time error '13' type mismatch) "Debug" and "Continue" Grayed out.
    By Jeronimo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2012, 06:42 PM
  6. Create chart from list that has associated "type"
    By leosgb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-05-2006, 02:38 AM
  7. [SOLVED] Where is the toolbar with the "bold type", "font type", options
    By fwccbcc in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-03-2006, 04:15 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